```json
{
    "title": "The Beauty of FULLTEXT Indices",
    "url": "https://performancezen.com/2005/01/18/the-beauty-of-fulltext-indices/",
    "datePublished": "2005-01-18",
    "dateModified": "2005-01-18",
    "language": "en-US",
    "description": "I insert all of my Web server hits into a MySQL database, and a few of the queries I run were really slow. Then I discovered that using FULLTEXT Searches,…",
    "author": "spierzchala",
    "publisher": "Performance Zen"
}
```

# The Beauty of FULLTEXT Indices

I insert all of my Web server hits into a MySQL database, and a few of the queries I run were really slow. Then I discovered that using FULLTEXT Searches, as opposed to LIKE or REGEXP, were far superior.

Cut the query time by 80%. Ouch.

If you use non-binary CHAR, VARCHAR, or TEXT columns, consider a FULLTEXT Index on those columns.