> From: Karl J. Stubsjoen
> Imagine: a table with over 200,000 records in it and one of > the fields in > the table is a keywords field. Keywords seperated by commas. > The keyword > field is a collection of keywords that our clients use to identify the > content of their web pages. > What we need to do is search this field, however it is a > field of somewhere > between 5 and 50 comma seperated keywords. > The question is: how to search within this field > effectively. Doing a like > "%findthis%", is 100% NOT optmizable. > > Do you have any suggestions? Note: I'm looking into the > FULLTEXT indexing > features of MySQL. > > Thanks! > > Karl > The new features (6.9.3 New Features of Full-text Search to Appear in MySQL 4.0) seemed to be geared to solve your problem. The advantage of using a feature which is part of the DBMS is that of a general solution. It may not be optimal but it is more likely to be robust and maintainable than a specialized solution. You may want to consider other options that are available such as those at http://www.google.com/services/index.html or from other commerical sources. I have not researched this subject recently but I am sure that there are many "search engine" solutions to be found. If you want to "roll your own" I suspect you won't go wrong using MySQL. Regards, Norman L. Smith --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
