ssage-
From: Robert Citek [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 5:44 PM
To: MySQL
Subject: Re: REGEXP email address query
Hello Richard,
At 05:06 PM 12/10/2002 -0800, Richard Baskett wrote:
>SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
>But I am doin
Hello Richard,
At 05:06 PM 12/10/2002 -0800, Richard Baskett wrote:
>SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
>But I am doing something wrong, because it's just not working :)
You are searching for an Email field that begins with an @.
Some alternatives:
SELECT * FROM `table_name
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
