mysql - mySQL 查询错误

Question

我有以下查询，我希望仅返回与 label_name“Ultra Music”匹配的记录，但它返回任何 label_name:

SELECT  `chart_rating` . * , SUM( chart_rating.rating_score ) AS total_score, release.release_label
FROM  `chart_rating` 
INNER JOIN  `release` ON  `chart_rating`.`rating_release_id` =  `release`.`id` 
WHERE MATCH (
release.release_label
)
AGAINST (
"Ultra Music"
IN BOOLEAN MODE
)
GROUP BY  `rating_release_id` 
ORDER BY  `total_score` DESC

我对release_artist有一个几乎相同的查询，它运行得很好。

这个查询有什么问题？

Answer 1

By default (when neither + nor - is specified) the word is optional, but the rows that contain it are rated higher. This mimics the behavior of MATCH() ... AGAINST() without the IN BOOLEAN MODE modifier.

MySQL Ref - Bool