php mysql search data with multiple keywords

Question

I currently have my query to have LIKE('%keyterm%'). It works fine if my data has one keyboard typed. But what if I want to type in two keywords. Then it will return false.

Example:

keyword : rock climbing
data in mysql: Rock Day Free Climb

This phrase should come out because it has Rock and Climb but it seems like LIKE is not enough?

What else would I need to get that query?

Thanks!

what about LIKE(%rock%) OR LIKE(%climbing%) or if its always first key and second key you can use rock%climbing as keyterm — Talisin
– Talisin, Commented Oct 7, 2011 at 3:26

nachito · Accepted Answer · 2011-10-07 03:26:11Z

1

You'll need to split on the whitespace and have a LIKE('%keyterm%') statement for each. See php.net/explode

answered Oct 7, 2011 at 3:26

nachito

7,0352 gold badges28 silver badges44 bronze badges

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

1 Comment

hellomello Over a year ago

Thanks, you guided me to the right direction. I figured it out

Anson · Accepted Answer · 2011-10-07 03:28:19Z

0

Return results containing either keyword1 or keyword2:

SELECT * FROM table WHERE data LIKE '%keyword1%' OR data LIKE '%keyword2%';

Return results containing both keyword1 and keyword2:

SELECT * FROM table WHERE data LIKE '%keyword1%' AND data LIKE '%keyword2%';

answered Oct 7, 2011 at 3:28

Anson

2,67423 silver badges18 bronze badges

1 Comment

hellomello Over a year ago

I have an OR statement in my query, and I'm searching the keyword as Rock Climbing, not rock then climbing.

Collectives™ on Stack Overflow

php mysql search data with multiple keywords

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related