如何在SQL查询和PHP中匹配字符串中的单词并检索数据？

Question

I have a MySql Table just like this

Brand 
--------
Honda
Sozuki
Oddi
.
.
.

Now there is an dynamic array in PHP :

$brand = ["Sozuki","Honda"]

The Question is how to retrieve data that matches the word in above array. I tried this :

$qry = 'select * from brand where brand Like '% $brand[0] %' and '% $brand[1] %';

It works fine but what would I do if I have no specific length of array, you can say dynamic array. Any solution will be appreciated Thanks

Answer 1

try

$qry = "select * from brand where brand ";
$i=1;
$count = count($brand); 
foreach($brand as $v) {
  $a = ($i < $count ? 'and' : '');
  $qry .=  " Like '% $v %'  $a ";
  $i++;
}
echo $qry;