mysql - 如何计算查询结果

Question

如何使用 COUNT 关键字计算此查询的结果？

SELECT COUNT (*) 返回错误结果。

SELECT files.* FROM files
LEFT JOIN tags_files ON tags_files.id_file = files.id
LEFT JOIN tags ON tags.id = tags_files.id
WHERE tags.name LIKE '%search%' OR files.name LIKE '%search%' 

Answer 1

如果你想计算结果，试试这个查询:

SELECT COUNT( files.id ) AS total_num FROM files
LEFT JOIN tags_files ON tags_files.id_file = files.id
LEFT JOIN tags ON tags.id = tags_files.id
WHERE tags.name LIKE '%search%' OR files.name LIKE '%search%'