php mysql搜索带有多个关键字的数据

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!

Answer 1

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