[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%'


Josh is correct this is the proper usage of NOT and LIKE.

However, you might want to look at using RegEx.


I think your request might look like:

         Select Col1,Col2,Col3 from Table1
         Where Col1 REGEX '^[^(a-z|A-Z)]'

Good luck.

Anthony Baratta
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."

More information about the thelist mailing list