MySql检查非unicode字符

I have a table in mySql and some of the rows have an é. And when I am running my script to use the values in the mySql it breaks because of this. I am trying to find all the rows that contain an "é" but it doesn't work? Here is what I am trying:

SELECT * FROM `Schools_Geocode` WHERE `column` LIKE 'é'

How can I find row that contains é