MySql REGEXP operator

Question

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

Answer 1

Use the BINARY keyword, which forces REGEXP to match the string as a binary string, which is done case-sensitively.

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

Although this isn't explicitly stated in the docs (that you can do it with a regular string), in my experience it works as expected.