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
6758
November 08, 2005 04:25PM
2762
November 08, 2005 08:03PM
Re: Storing Keywords
2490
November 09, 2005 04:13AM


Sorry, you can't reply to this topic. It has been closed.

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.