Not Like

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Not Like

Post 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
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

what about

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.
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Mr. Tech
Forum Contributor
Posts: 205
Joined: Tue Feb 11, 2003 4:18 pm
Location: Australia

Post by Mr. Tech »

THANKS! :D
Post Reply