MySql REGEXP statement

Question

The mySql REGEXP statement is not case sensitive. Is there a version of this operator in which case sensitive?

+3

Ed heal Apr 25 '12 at 12:41

1 answer

Michael berkowski · Accepted Answer · 2012-04-25T12:44:44+0000

Use a keyword BINARYthat makes the REGEXPstring match a binary string that is case sensitive.

SELECT 'a' REGEXP 'A', 'a' REGEXP BINARY 'A';

Although this is not explicitly stated in the docs (that you can do it with the usual string), in my experience it works as expected.