html mysql全文搜索查询多个单词

Question

Here is search engine with php

<form action='search_query' method='POST'>
 <input type='text' name='keyword' />
 <input type='submit' value='submit' />
</form>

I want to search the data if a person type two words.

if the keyword is 'red dog'

It should search like this on my-sql.

SELECT * FROM `DATA` WHERE `TITLE` LIKE '%red%' and '%dog%';

I want to know how to recognize when a person types multiple words.

Answer 1

I want to know how to recognize when a person types multiple words.

How do you define "multiple words"? Are those words with a space in between? Then explode() the input on spaces, and build your query from the result of that.