mysql 带全文查询的SELECT count()

a11xaf1n 于 2023-08-02 发布在 Mysql

关注(0)|答案(1)|浏览(77)

统计以下查询结果的正确语法是什么？

SELECT title,keyword, MATCH(title) AGAINST ('keyword' IN BOOLEAN MODE) AS relevance 
FROM video 
WHERE MATCH (keyword) AGAINST ('keyword' IN BOOLEAN MODE) 
    AND active = "1" 
ORDER BY relevance DESC

字符串

mysql

来源：https://stackoverflow.com/questions/76813162/select-count-with-full-text-query

1条答案

按热度按时间

9q78igpj1#

只需将选择列表替换为COUNT(*)即可获得计数。

SELECT COUNT(*) AS total
FROM video 
WHERE MATCH (keyword) AGAINST ('keyword' IN BOOLEAN MODE) 
    AND active = "1"

字符串

赞(0）回复(0）举报 2023-08-02

我来回答

mysql 带全文查询的SELECT count()

1条答案

相关问题

热门标签

最新问答