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?

SqlACID · Accepted Answer · 2010-04-20 02:11:20Z

7

How about:

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

answered Apr 20, 2010 at 2:11

SqlACID

4,02423 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mike Over a year ago

This doesn't work well because users are performing a search and I don't know how many keywords they are entering.

Duncan Over a year ago

@mike: You can't build a query with an arbitrary number of conditions? It shouldn't be any different from building a pattern match string

maček · Accepted Answer · 2010-04-20 02:13:08Z

5

Another option

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

answered Apr 20, 2010 at 2:13

maček

78k37 gold badges172 silver badges200 bronze badges

2 Comments

mike Over a year ago

This worked perfectly. I never used rlike before. I'm going to have to read up on how well that performs, but it does work! thanks!

Duncan Over a year ago

This will match titles with either term, which may not be what you want, e.g. If the user types in "Playstation Game" it will still return "Xbox 360 Video Game"

Collectives™ on Stack Overflow

SQL Like question

2 Answers 2

2 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Related