[thelist] MySQL query: not like a, b, c,...
Anthony Baratta
anthony at baratta.com
Thu Apr 8 22:13:43 CDT 2004
>
>user NOT LIKE 'z%'
Mike...
Josh is correct this is the proper usage of NOT and LIKE.
However, you might want to look at using RegEx.
http://www.mysql.com/doc/en/Regexp.html
I think your request might look like:
Select Col1,Col2,Col3 from Table1
Where Col1 REGEX '^[^(a-z|A-Z)]'
Good luck.
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list