统计以下查询结果的正确语法是什么?
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
字符串
9q78igpj1#
只需将选择列表替换为COUNT(*)即可获得计数。
COUNT(*)
SELECT COUNT(*) AS total FROM video WHERE MATCH (keyword) AGAINST ('keyword' IN BOOLEAN MODE) AND active = "1"
1条答案
按热度按时间9q78igpj1#
只需将选择列表替换为
COUNT(*)
即可获得计数。字符串