SQL Like question
- by mike
Is there a way to reverse the SQL Like operator so it searches a field backwards? For example, I have a value in a field that looks like this "Xbox 360 Video Game". If I write a query like below, it returns the result fine.
SELECT id FROM table WHERE title like "%Xbox%Game%"
However, when I search like this, it doesn't find any results.
SELECT id FROM table WHERE title like "%Video%Xbox%"
I need it to match in any direction. How can I get around this?