Is there any mySQL function opposite to the LIKE...???

I have a data in a table of mySQL…

PILDMORN-OK(ODAT)RDS-UP(STAT)

now I have to select data from another table if it matches only a certain part of this data…PILDMORN-OK

I need the reverse functionality of the LIKE…

well…to make the problem more clear…I DO NOT require all subsets to be selected…

for ABCDE as the input…i require only A,B,C,D,E or AB,BC,CD,DE or ABC,BCD,CDE or ABCD,BCDE or ABCDE to be selected…and nothing else

A reply would be much appreciated…

Thanks

You can use “NOT LIKE”

Nimol,
Programmer
Corbin Creative Databases, LLC, http://www.corbincreative.com