John Taylor-Johnston wrote: > Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I > get results in no real structured heirachy. Any thoughts? > > <SELECT ST,BT,AT FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret > atwood' IN BOOLEAN MODE);><h1>Search <font > color="blue">ccl.ccl_main</font> For: <font color="blue"><i>margaret > atwood</i></font> - 275 record(s) found</h1> > > John
The results from IN BOOLEAN MODE are not sorted in order of relevance, from what I can see in the docs. More info can be found at http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html Depending on what you are trying to achieve, BOOLAEN MODE may not be what you want. David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php