Categories
mysql utf-8

How to conduct an Accent Sensitive search in MySql

I have a MySQL table with utf8 general ci collation. In the table, I can see two entries:

abad

abád

I am using a query that looks like this:

SELECT *  FROM `words` WHERE `word` = 'abád'

The query result gives both words:

abad

abád

Is there a way to indicate that I only want MySQL to find the accented word? I want the query to only return

abád

I have also tried this query:

SELECT *  FROM `words` WHERE BINARY `word` = 'abád'

It gives me no results. Thank you for the help.