MySQL Case Sensitive Searching

Published On: 2011-09-08

Category: Jargon Jabberwocky

By default MySQL and other engines search using a case insensitive method. You can tell MySQL to do a case sensitive search by changing the COLLATION of the field your searching.
SELECT *
FROM `table`
WHERE `field`
COLLATE latin1_general_cs LIKE '%SeaRch TeRm%'