MySQL Question
| From: | John Taylor-Johnston | Date: | Thu, 15 Jan 2004 18:26:51 +0000 |
| Subject: | MySQL Question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-174685@lists.php.net to get a copy of this message | ||
Sorry, don't want to be off-topic, but have found something curious about MySQL
4.0.16-standard.
It does not seem to prioritise properly. Searching for 'English Canada'
(as opposed to +English +Canada)
gives me all instances of both words but does not prioritize the display order for
'English Canada' first and then 'English' then 'Canada'.
SELECT * FROM ccl_main WHERE MATCH
(YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,KW,AUS,GEO,AN,RB,CO) AGAINST ('English
Canada' IN BOOLEAN MODE)
ORDER BY id asc;
versus
SELECT * FROM ccl_main WHERE MATCH
(YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,KW,AUS,GEO,AN,RB,CO) AGAINST ('English
Canada' IN BOOLEAN MODE);
gives the same order.
Anyone know of an article that might help me control the priority.