I'm sure this is a common and simple situation: say I have a title, url, description fields, assume they makeup a record in one table named book_info. Say for each of this table's records I also need a keywords field (of type text) and I'll use a fulltext index on this field. Great, now the user does a search (w/mysql/php eg.) the keyword(s) are found and the associated records display - a nice dynamic web page.
I assume it's OK to throw a bunch of keywords into a text field and use fulltext on it in this fashion. It seems simple and easy to conceptualize this at least. Question is, were do I put the keywords field? Do I add it to the end of book_info then just query the keywords field in each book_info record and select everything to render except the keywords field when a match is found. Or, have a separate keyword table and have corresponding auto-increment PK fields on the book_info and keyword tables, and search the keyword_keyword field w/fulltext and then do a simple join on the PK's of each table to select the corresponding book_info results. Either way will work, what's better? Thanks, Lee G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
