Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Best way for search tags

shootmeshootme EntrantCurrent User Role Beginner
I have a one column string(255) filled by on word - tag name, for example, radio or music. What the best way (best search result and search time) to find tags? user can input "ra" or "rad" and radio word must be present in results. Thank you.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi shootme;

    If you are using MyISAM or MySQL 5.6+ with InnoDB then you may use the built-in full text search functionality which is pretty straight forward:
    http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

    Otherwise you'll just be using a normal index if it's an InnoDB table on MySQL 5.5 or lower. If you search only for words that "start with" a value, such as your radio example, then those are pretty quick using a "WHERE tag LIKE "rad%";" since that may use the standard index. If you want the functionality of "CONTAINS", such as searching for "adi" and finding "radio", then in that case the index will not be of any help. To optimize the "starts with" case further, you could do some analysis on your tag data and find a prefix value to use that would give you adequate selectivity while keeping the index smaller.

    -Scott
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.