http://snippets.dzone.com/posts Wed, 23 Jul 2008 15:34:31 GMT DZone Snippets: regex code http://snippets.dzone.com/posts/show/5011 <code> <br />SELECT * FROM texts WHERE content REGEXP '[^a-z]Hello[^a-z]' ; <br /></code> <br /> <br />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. <br /><code> <br />SELECT * FROM texts WHERE content REGEXP BINARY '[^a-zA-Z]Hello[^a-zA-Z]' ; <br /></code> <br /> <br />Warning: some characters do not work. Example : <br /><code> <br />SELECT * FROM texts WHERE content REGEXP '[^\w]Hello[^\w]' ; <br /></code> <br /> <br /><a href="http://www.ab-d.fr/">ab-d.fr source code</a> <br /> <br /> Sat, 19 Jan 2008 22:05:22 GMT http://snippets.dzone.com/posts/show/5011 ki4ngel (Benoit Asselin)