Mysql 查询 Match and OR WHERE

Question

你好，如果有这个问题:

 SELECT *,
      MATCH(tags) AGAINST ('book library' IN BOOLEAN MODE) AS resources_score 
      FROM books  HAVING resources_score > 0 
      ORDER BY resources_score DESC, id DESC ; 

是否可以添加OR WHERE title LIKE ;

此外，由于我的查询将 resource_score 返回为 1 或 0 ，是否可以提高查询/搜索/结果的准确性？

最后，一个提示dubt，查询匹配精度取决于记录数？

感谢谁会帮助我

Answer 1

当所有其他方法都失败时，您可以使用算术组合 SQL 函数。

 SELECT *,
 (title LIKE '%pattern%') + (MATCH(tags) AGAINST ('book library' IN BOOLEAN MODE))
   AS resources_score 
 FROM books HAVING resources_score > 0 
 ORDER BY resources_score DESC, id DESC ;

当标题包含“pattern”时，这会将 MATCH() 返回的分数加 1。