Category: >> mySQL >> Binary RegExp select example Bookmark and Share

<< lastnext >>

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)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT * FROM texts 
WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ;
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 9