php - 我们如何根据 php 和 mysql 中关键字的出现对搜索结果进行排序

Question

下面是我的查询:

这个查询工作正常，但现在我希望这个查询结果按关键字出现进行排序。例子:在我的数据库中:

srno| name          | business                         |city 
  - | ------------- | -------------------------------  |-------
  1 | janefer group | advertisement company import     |manchester
  2 | abc           | golf import export               |new york
  3 | xyz           | golf import                      |new york

如果我在搜索框中传递关键字$search ="高尔夫导入导出 xyz";

然后我想要的结果是所有与此帖子匹配的关键字都排在第一位，依此类推

查询

$qry="SELECT *, MATCH (name,business,city) AGAINST ('$serach*' IN BOOLEAN MODE) AS Relevance FROM tbl_services WHERE MATCH (name,business,city) AGAINST ('$serach*' IN BOOLEAN MODE)  ORDER BY Relevance DESC LIMIT 1 , 12"

Answer 1

您在查询中拼错了单词 $search 试试这个

$qry="SELECT *, MATCH (name,business,city) AGAINST ('$search*' IN BOOLEAN MODE) AS Relevance FROM tbl_services WHERE MATCH (name,business,city) AGAINST ('$search*' IN BOOLEAN MODE)  ORDER BY Relevance DESC LIMIT 1 , 12"