MySQL Forums
Forum List  »  MyISAM

Re: Storing Keywords
Posted by: Ingo Strüwing
Date: November 09, 2005 04:13AM

Right. I would try to leave the keywords out of the records an make a second table like so:

// -- keyword -- id -- \\

john 654
john 544
john 8645
apple 654
fastfood 654
fastfood 8743
...

In principle this means indexing the original table by keywords.
Or, in other words, building a kind of index that MySQL cannot do for you because the index values are not necessarily literally contained in the data and not all words of the data shall be indexed.

A fulltext index may be a good compromise when people are lazy to assign good keywords.

Ingo

Options: ReplyQuote


Subject
Views
Written By
Posted
7056
November 08, 2005 04:25PM
2872
November 08, 2005 08:03PM
Re: Storing Keywords
2634
November 09, 2005 04:13AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.