由于您在下面更新了您没有使用php se
var searchQuery = "orange llp";
var splitQuery = searchQuery.split(" ");
var sqlQuery = "SELECT * FROM table WHERE ( name";
for(i = 0; i < splitQuery.length; i++){
var query = splitQuery[i];
sqlQuery += " LIKE '%" + query + "%' OR name ";
}
sqlQuery += " LIKE '%" + searchQuery + "%' )";
//Now run your query like below
con.query(sqlQuery);
您的输出查询如下所示
SELECT * FROM table WHERE ( name LIKE '%orange%' OR name LIKE '%llp%' OR name LIKE '%orange llp%' )
将这个类php search controller用于php版本
$searchQuery = "orange llp";
$search = new SearchController(SearchController::OR);
$search->setOperators(SearchController::HAVE_ANY_QUERY);
$search->setQuery($searchQuery)->split();
$search->setParameter(array('name', /*more columns to search on*/));
$sqlQuery = "SELECT * FROM table {$search->getQuery()}";
您还可以添加其他线索
$sqlQuery = "
SELECT * FROM table {$search->getQuery()}
AND id = anything else
";