How to search for a clear occurrence in full text search?

Question

MySQL

Used the search with like 'abc%'
There is a lot of data, the search now slows down.
I made an index in the table for full-text search, but when you search using full-text, the result is rows similar to those you are looking for but not suitable.
For example, I'm looking like this:
SELECT * FROM articles WHERE MATCH (title, body) AGAINST ('mail.ru');

as a result, the following will be displayed:
mail.ru
mail.ua
your.mail.ru
your.mail.ua

, etc.

I would like to use full-text search but have as a result of the query only what fits the search and does not look like it.

Answer 1

Try adding double quotes around your search phrase.

A phrase that is enclosed within double quote (") characters matches only rows that contain the phrase literally, as it was typed

doka