按资本或小写字母搜索单词

Question

I have two values in the database like

1. This is Name
2. this is a name

I am searching a phrase th by SQL query

SELECT * FROM [TABLE_NAME] WHERE title LIKE '%th%'

then both filed is showing where I want only to show this is a name part. How should I proceed. I have tried preg_merge and other parts but they didn't work. Is there any SQL Query which can distinguish capital and small letter. Or any php method by which I can search exact term. My table format is UTF8. Not Latin General.

Answer 1

it will work for you, try this query

SELECT * FROM table_name WHERE BINARY title LIKE '%th%'