且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在MySQL中搜索多个单词

更新时间:2023-11-20 15:24:58

您可以尝试--

$words = explode(' ', $word);
$query = "SELECT * FROM table WHERE table.keywords IN (".implode(',', $words).")";

或-

$query = "SELECT * FROM table WHERE";
$conds = array();
foreach ($words as $val) {
    $conds[] = "table.keywords LIKE '%".$val."%'";
}
$query .= implode(' OR ', $conds);

可以根据需要添加支票.

The checks can be added if required.