full-text search
The MariaDB feature for finding words, phrases, Boolean combinations of words, and so on within table data, in a faster, more convenient, and more flexible way than using the SQL LIKE
operator or writing your own application-level search algorithm. It uses the SQL function MATCH()
and FULLTEXT indexes.
See also FULLTEXT index.