256 Kilobytes

Answers in Database Development | By August R. Garcia

Published

271 views, 1 RAM, and 0 comments

Tags: MySQL, Queries, Database Indexing

Profile Photo - August R. GarciaAugust R. GarciaLARPing as a Sysadmi...Portland, ORSite 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 (11 months ago)
🐏 ⨉ 1
Posted by August R. Garcia 11 months ago 🕓 Posted at 07 August, 2019 21:08 PM PDT

Sir, I can do you a nice SEO.

Post a New Comment

Do you like having a good time?

Register an Account

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

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

Answers— Read More

Find more related content below!