GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    You can use "NOT LIKE"

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

    Comment

    Working...
    X