256 Kilobytes

Answers in Database Development | By August R. Garcia

Published 2 weeks agoWed, 07 Aug 2019 21:08:27 -0700

49 views, 1 RAM, and 0 comments

Tags: MySQL, Queries, Database Indexing

Profile Photo - August R. Garcia August R. Garcia LARPing as a Sysadmi... Portland, OR
🗎 178 🗨 895 🐏 266
Site Owner

Regular indexes are basically irrelevant if you need string matching within arbitrary positions in a string (rather than only at the start). The solution is to use the built-in fulltext search feature in MySQL. While this won't find every string match, it will find the matches that have that full word in it. Read the documentation for other setups, etcetera.

Create an index on an existing table:

  • CREATE FULLTEXT INDEX idx_name ON keywords(name) 

Query the table:

  • SELECT * FROM keywords WHERE MATCH(name) AGAINST('goat' IN NATURAL LANGUAGE MODE)
    • This will match "definition of done mountain goat" but not "texmaster goats for sale in oklahoma"

See:

Users Who Have Downloaded More RAM:
Huevos Rancheros (2 weeks ago)
🐏 ⨉ 1
Posted by August R. Garcia 2 weeks ago 🕓 Posted at 07 August, 2019 21:08 PM PDT

Sir, I can do you a nice SEO.

Post a New Comment

To leave a comment, login to your account or create an account.

Do you like having a good time?

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account
You can also login to an existing account or recover your password. All use of this site is subject to terms outlined in the terms of service and privacy policy.