[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