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, 1713🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...