Mega Code Archive

 

Categories / MySQL / Regular Expression

 

The command REGEXP offers many more possibilities for formulating a pattern

mysql> mysql> SELECT 'abcabc' REGEXP 'abc', 'abcabc' REGEXP 'cb'; +-----------------------+----------------------+ | 'abcabc' REGEXP 'abc' | 'abcabc' REGEXP 'cb' | +-----------------------+----------------------+ |                     1 |                    0 | +-----------------------+----------------------+ 1 row in set (0.00 sec)