Why doesn't mysql index work?

Question

MySQL

Created an index like this:

ALTER TABLE news ADD FULLTEXT INDEX idx_content (content)

I see index has been created:
Request:

SELECT * FROM news WHERE MATCH (content) AGAINST ('book') LIMIT 10

But in the end the result is irrelevant. entries with fewer matches are returned first, and so on.

Answer 1

Because WHERE does not sort the result, but only filters by condition.