I have a mySQL database with a table of email addresses but some of the email addresses have single quotes for odd 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 to find them

SELECT * FROM tbl_email WHERE LOCATE("'",user_email) > 0