Mega Code Archive

 

Categories / MySQL / Regular Expression

 

Usage of the % wildcard

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