I would like to search an email address field for all values that do not have a '@' in them. How would I go about doing this?
So far this query is what I have: SELECT * FROM `table_name` WHERE Email REGEXP "^[@]"; But I am doing something wrong, because it's just not working :) Thanks! Rick "Dost thou love life? Then do not squander time; for that's the stuff life is made of." - Ben Franklin --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php