Mega Code Archive

 

Categories / MySQL / Regular Expression

 

The % wildcard returns any number of characters

mysql> mysql> SELECT 'abcd' LIKE '%b%'; +-------------------+ | 'abcd' LIKE '%b%' | +-------------------+ |                 1 | +-------------------+ 1 row in set (0.00 sec)