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
- matt.goodwin's blog
- Login to post comments
