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>