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, 1458🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...