Hey.

Tell me why invented this search? Where should I use it? As I understand it, the limitation of its applications is great - only in certain types of tables and field types. Is it used only to sort the result depending on the accuracy of the match?

Practical question:

$sql="SELECT * FROM `articles` WHERE MATCH (title,body) AGAINST('How')";

I have the word How in the title field. Why sampling does not occur. There are no errors. There is such a string in the title field:

How To Use MySQL Efficiently

    1 answer 1

    The search is generally coined to find results by sample. FullText search - coined to find a word or combination in a text field based on morphology.

    Benefits of searching with the LIKE operator:

    • a slight increase in request processing time as its complexity increases
    • ability to sort the results
    • versatility: can be used to search rpakticheski for any type of field, in contrast to the full text

    Disadvantages of LIKE:

    • lack of morphology support
    • no modifiers
    • search all lines

    Benefits of full-text search:

    • morphology support
    • issue of results by relevance
    • the presence of modifiers that are similar to the modifiers in Google and Yandex
    • stop words
    • ability to customize

    Disadvantages:

    • lack of sorting
    • support only VARCHAR and TEXT fields with indexes FULLTEXT
    • resource-intensive process
    • support for MyISAM tables, sort of like with 5.5 added to InnoDb
    • with the FULLTEXT key set, adding data to the table takes longer

    For high-quality full-text search, I recommend using a sphinx or percona server, where the sphinx is already embedded.