Re: MySQL question
| From: | David Robley | Date: | Wed, 23 Jun 2004 07:14:03 +0000 |
| Subject: | Re: MySQL question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-188853@lists.php.net to get a copy of this message | ||
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