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, 1248🔥, 0💬
Popular Posts:
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...