like operator issue

Posted by Domnic on Stack Overflow See other posts from Stack Overflow or by Domnic
Published on 2010-05-18T07:19:31Z Indexed on 2010/05/18 7:20 UTC
Read the original article Hit count: 314

Filed under:

I have dom table

select * from dom

dom table details:

id name skills 1 dom c,c++

here i want to retrive query using like operator

select * from dom where skills like '%c,c++%' then i got the desired result.....thats not a problem

suppose if i want to use the belove query select * from dom where skills like '%C++,C%' i didnt get result

So i have to show details even if i search reverse order in database

how can i?

© Stack Overflow or respective owner

Related posts about sql