Is regex case sensitive mysql?

Discussion. Currently, REGEXP is not case sensitive , either. Both expressions are true because [:lower:] and [:upper:] are equivalent when case sensitivity doesn’t matter.

Java Regular Expressions are case-sensitive by default .

REGEXP is not case sensitive, except when used with binary strings .

In Java, by default, the regular expression (regex) matching is case sensitive. To enable the regex case insensitive matching, add (?) prefix or enable the case insensitive flag directly in the Pattern .

Using character sets For example, the regular expression “[ A-Za-z] ” specifies to match any single uppercase or lowercase letter . In the character set, a hyphen indicates a range of characters, for example [A-Z] will match any one capital letter.