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.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
