December 31, 2020

Updated April 2026. MySQL’s FULLTEXT indexes turn the classic LIKE ‘%keyword%’ pattern into a proper natural-language search — fast, ranked, and stopword-aware. On a one-million-row text column the difference is