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, 1341🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...