How To Use LIKE Conditions

Q

How To Use LIKE Conditions? - MySQL FAQs - Introduction to SQL Basics

✍: FYIcenter.com

A

A LIKE condition is also called pattern patch. There are 3 main rules on using LIKE condition:

  • '_' is used in the pattern to match any one character.
  • '%' is used in the pattern to match any zero or more characters.
  • ESCAPE clause is used to provide the escape character in the pattern.

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

2007-05-11, 4256👍, 0💬