special characters

When I run the following query:

SELECT * FROM words w where SUBSTRING(w.tword,1, 1) = 'é';

I get all w.tword that start with 'e', 'é', 'E', and 'É'

Any advice on how to limit it to exactly the words that start with
'é'?

Thanks for your time!

Mandragon

On 7 Jun, 19:05, Mandrago...@gmail.com wrote:
> When I run the following query:
>
> SELECT * FROM words w where SUBSTRING(w.tword,1, 1) = 'é';
>
> I get all w.tword that start with 'e', 'é', 'E', and 'É'
>
> Any advice on how to limit it to exactly the words that start with
> 'é'?
>
> Thanks for your time!
>
> Mandragon

You need to use the BINARY operator:

http://dev.mysql.com/doc/refman/5.0/...binary-op.html