Database Administration
Search Text With a MySQL FULLTEXT Index
Replace a slow LIKE '%word%' with a FULLTEXT index: rank matches by relevance in natural-language mode, require or exclude terms in boolean mode, and…
//
Tag: EXPLAIN
Database Administration
Create an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…