MySQL Forums
Forum List  »  MyISAM

Re: Storing Keywords
Posted by: Jay Pipes
Date: November 08, 2005 08:03PM

You could use FULLTEXT indexing:

http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html

or alternately, you could split the keywords into a one-to-many relationship table with each keyword/category being stored in each record.

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com



Edited 1 time(s). Last edit at 11/08/2005 08:04PM by Jay Pipes.

Options: ReplyQuote


Subject
Views
Written By
Posted
6759
November 08, 2005 04:25PM
Re: Storing Keywords
2762
November 08, 2005 08:03PM
2491
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.