Mega Code Archive

 

Categories / MySQL / String

 

Using Binary with REGEXP

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