Hi, a few weeks ago I spotted part "6.8 MySQL Full-text Search" of the manual the first time. Reading through the lines gave me the impression it's nice but lacking some features I need - unless I misunderstand the manual.
a.) no relevance in boolean mode (?) Is there any chance to sort the results of a boolean search according their relevance, what kind of workarounds are you using? One could for example sort by a the most "descriptive" field of a tale like say the "title" field of an article table. Any other idea? As I'm afraid one can't order the search result by relevance what is the benefit of match/against/fulltext in boolean mode compared to regular indexes and a client side parser that translates the user provided search string into a sequence of 'field like "%keyword% and|or ...'? b.) to many results versus no results How do I find out if a query resulted in two many results or no results? As I understand the manual in both cases an empty record set will be returned. Thanks in advice! Ulf --------------------------------------------------------------------- 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
