Page 1 of 1

How to ignore a string during a query?

Posted: Thu Oct 19, 2006 10:08 am
by ridshack
Hi,

I have a field with two types of names in it. One is just a name no spaces and the other is a email address. Im tring to query the field pulling out only the names that are not email addresses.

Any ideas on how I can ignore the names with the @domain.com?

Thank you,
Jason

Posted: Thu Oct 19, 2006 10:09 am
by feyd
NOT LIKE '%@domain.com' or, if the domain varies, a similar REGEXP statement.

Posted: Fri Oct 20, 2006 1:31 am
by ridshack
Its so easy once you know the answer... Thank you very much. Ill be looking up REGEXP.