mySQL table contains single quotes

I have a mySQL database with a table of email addresses but some of the email addresses have single quotes for some reason.
I'll need to add some validation to my form eventually.
I need to find them and fix them now.
Here's the SQL

select * from tbl_email where LOCATE("'",user_email) > 0