Mega Code Archive

 

Categories / MySQL / Regular Expression

 

An underscore (_) matches only one character exactly

mysql> mysql> SELECT 'abcd' LIKE 'a_ _ _'; +----------------------+ | 'abcd' LIKE 'a_ _ _' | +----------------------+ |                    0 | +----------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 'abcd' LIKE 'a_ _'; +--------------------+ | 'abcd' LIKE 'a_ _' | +--------------------+ |                  0 | +--------------------+ 1 row in set (0.00 sec) mysql>