like operator issue
- by Domnic
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?
