Full-text search for MySQL FULLTEXT indexes using

Recently I had to search on the site of the advertising agency, where the content is the page with the text. In order that you could search for VARCHAR and TEXT fields I used FULLTEXT indexes. Small description with examples below.
MySQL supports FULLTEXT indexes since version 3.23, this allows a full search for columns of type VARCHAR and TEXT columns using a SQL expression. To begin with, we need to create the FULLTEXT index. Code sample:


This is not a complex expression we have added FULLTEXT index for title and content fields table articles. As you can see, you can add a FULLTEXT index on multiple columns at once. How do you search now? Very simply:
This is not a complex expression we choose from table articles title field content, all of the records where MySQL will find the words “Search in MySQL” in the title, the content columns. The search is case-insensitive. In addition, MySQL sorts results in descending order of relevance. How it happens and what does it mean? MySQL creates a relevance value as a floating point number, depending on how exact match is found, and then sorts the data in descending order. When you wish, you can obtain this number:
As you can see there are two functions to search for MATCH and AGAINST.
The MATCH function is used to define the column (s) to be searched. A list of the columns in the MATCH must be defined within the index FULLTEXT.
AGAINSTfunction performs a direct search.
You can use Boolean mode for a more advanced search. For example, perform a search of all articles in which the word Boolean but not the word “treatment”:


How does it work? If you do not specify the symbols “+” or “-MySQL is looking for any word from the list in each entry (the analogy with the operator). If you specify “+” symbol, MySQL will select the entries where this Word includes, (like the AND operator). If you specify the “-symbol, MySQL will select the entries that a given word is not (as the NOT operator).
A more detailed description can be found at PHPClub or in official documentation of MySQL.
As you can see, nothing complicated. Ask your answers. Yes, Yes. I can accept a lot of errors, but the phrase ask your answers” just an Internet meme. For many shops, I got stupid and write such nonsense. I will not argue, but this is not the case.