Hi!
I know that mysql uses rlike to find word that are like, but how do I find results that are not like?
Thanks,
Ben
Not Like
Moderator: General Moderators
what about
SELECT * from some.table WHERE some.field NOT RLIKE something
Mark
SELECT * from some.table WHERE some.field NOT RLIKE something
Mark
Last edited by JayBird on Mon Sep 15, 2003 4:37 am, edited 1 time in total.
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
The manual is quite useful:
http://www.mysql.com/doc/en/String_comp ... tions.html
The opposite of RLIKE is NOT RLIKE...
Mac
http://www.mysql.com/doc/en/String_comp ... tions.html
The opposite of RLIKE is NOT RLIKE...
Mac