Is there a unique like?
Posted by: Deepak K
Date: November 29, 2011 10:01PM

I have to use LIKE in one of my columns. But the problem is that when i am using LIKE %abc% both abc, dabcd, abcde etc are selected together. But my requirement is a bit different.

What i need is:

If there are rows with entries abc,dsa abc, abcd etc when I select i have to get abc, and dsa abc rows.

Is this possible. Someone please comeup with a soulution.

Options: ReplyQuote

Written By
Is there a unique like?
November 29, 2011 10:01PM
January 09, 2012 07:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.