SQL Like question

Question

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?

Answer 1

Another option

SELECT id FROM table WHERE title RLIKE "(Xbox|Video)"

Answer 2

How about:

SELECT id FROM table WHERE title like "%Video%" and title like "%Xbox%"