如何在mysql中使用更多单词的条件

Question

I have a filed in database in which there is a text with a lot of words. In my front end i created a search box in which i would filter in many ways. I could write only one word or a lot of words and i should able to find the correct filed in which there are theese words. Actually i use the LIKE condition but this condition works only if i write one word or if the words are as written in the database with same order.. Is it possible do it even if the words i write are in "random order"? this is the example i use:

$sql = "SELECT * FROM table WHERE description LIKE '%".$description."%' ";

Answer 1

Use explode and implode with OR condition for each words.

$descriptionArr = explode(" ", $description);
if(!is_null($descriptionArr)) {
   foreach($descriptionArr as $search) {
     $descriptionQuery[] = " description LIKE '%{$search}%' ";
   }
   $condition = " WHERE " . implode(" OR ", $descriptionQuery);
}
$sql = "SELECT * FROM table {$condition}";