Case Sensitive LIKE in MySQL?

[random1]

Hi All!

 

I've got the following simple example code I've created for  a db table "simple_search":

 

SELECT `sid`, `sbody`, `stitle`, `sdescription` FROM `simple_search` WHERE `stitle` LIKE '%the%' ORDER BY `stitle` LIMIT 10;

 

It currently returns records that have "the", "The", "THE", "thE" etc for the title.

 

How can I make a case-sensitive version of this that ONLY returns records that match "the"?

 

I'm using the collation 'utf8_unicode_ci" and the engine "InnoDB".

[blacknight]

try using BINARY

 

SELECT `sid`, `sbody`, `stitle`, `sdescription` FROM `simple_search` WHERE BINARY
`stitle` LIKE '%the%' ORDER BY `stitle` LIMIT 10;

[random1]

Thanks blacknight That worked