Collections:
Using LIKE Conditions in MySQL
How To Use LIKE Conditions in MySQL?
✍: FYIcenter.com
A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition:
The following tutorial exercise provides you some good pattern matching examples:
SELECT 'FYIcenter.com' LIKE '%center%' FROM DUAL; 1 SELECT 'FYIcenter.com' LIKE '%CENTER%' FROM DUAL; 1 -- Case insensitive by default SELECT 'FYIcenter.com' LIKE '%CENTER_com' FROM DUAL; 1
⇒ Using Regular Expression with REGEXP in MySQL
⇐ Using IN Conditions in MySQL
2018-03-24, 1270🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...