How to correctly make Mysql "exact" like query?

Question

MySQL

There is a table with articles,

In it I need to find all the records where the word " trọn " occurs in the article

SELECT * FROM `url_content` WHERE `content` LIKE '% trọn %' limit 2

How to make a request correctly so that there are NOT similar words, for example: "tron", trơn" and so on?

Answer 1

My solution was the following:
It was possible to LIKE, but I went by MATCH AGAINTS since all articles weigh about 70 GB.
And then in PHP - strpos(); to find a specific key.
That turned out to be the fastest.

Answer 2

1. Use not LIKE, but substring search functions (INSTR or LOCATE)
   
2. Set required collation (up to BINARY)
   

Answer 3

Learn regular expressions. Then you will be able to build the query very precisely.