Snippet Name: Binary RegExp select example Description: If you really want to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string. Comment: (none) Language: MYSQL Highlight Mode: MYSQL Last Modified: March 01st, 2009
Description: If you really want to force a REGEXP comparison to be case sensitive, use the BINARY keyword to make one of the strings a binary string.
SELECT * FROM texts WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ;
