Guest mndfchstr Posted January 7, 2008 Share Posted January 7, 2008 Hello.A while back when working on my site, I made a form which could be submitted even if it was empty. It was a comment form. So people could submit an empty form and it'd go in the database then show up on my website as, well, nothing.I know i know, I was wild and crazy back then. I'm just wonder, I wanted to delete all the comments where the "textarea" field is empty.How would I do this? I've triedDELETE FROM Comments WHERE Comment = ''but it doesn't seem to work.Any help is greatly appreciated.Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted January 8, 2008 Share Posted January 8, 2008 You can try checking for null values.DELETE FROM comments WHERE comment IS NULL Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.