Page 1 of 1

Not Like

Posted: Mon Sep 15, 2003 4:04 am
by Mr. Tech
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

Posted: Mon Sep 15, 2003 4:29 am
by JayBird
what about

SELECT * from some.table WHERE some.field NOT RLIKE something

Mark

Posted: Mon Sep 15, 2003 4:34 am
by twigletmac
The manual is quite useful:
http://www.mysql.com/doc/en/String_comp ... tions.html

The opposite of RLIKE is NOT RLIKE...

Mac

Posted: Mon Sep 15, 2003 5:48 am
by Mr. Tech
THANKS! :D