Quick Search:
 
 mySQL: Binary RegExp select example Jump to:  
Category: >> mySQL >> Binary RegExp select example  

<< 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)

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

SELECT * FROM texts 
WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ;
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org