php - 如何在 MySQL 查询中搜索多列？

Question

如何搜索多列，此代码搜索单列，请自定义我的代码

$keywords= "search keywords";
$keywords= htmlspecialchars($keywords);    
$keywords= mysqli_real_escape_string($con, $keywords);
$countSql_s = "SELECT *, MATCH(website) AGAINST ('%".$keywords."%') AS score FROM search WHERE MATCH(website) AGAINST ('%".$keywords."%') ORDER BY score DESC";

Answer 1

只需更改“WHERE”以包含对每列的检查，如下所示:

... WHERE MATCH(website) AGAINST('%".$keywords."%') > 5
AND MATCH(username) AGAINST('%".$keywords."%') > 5
...