Ima nesto trulo u drzavi Danskoj (ili odakle je vec mysql..)
Naime, kad zadam sledeci upit:
Kôd:
SELECT q_query FROM k_queries
WHERE MATCH (q_query) AGAINST ('+car +insurance +quote' IN BOOLEAN MODE)
AND q_query <> 'car insurance quote'
ORDER BY q_times
DESC LIMIT 25;
dobijem sledece rezultate:
Kôd:
+-----------------------------------------------+
| q_query |
+-----------------------------------------------+
| state farm auto insurance quote |
| online auto insurance quote |
| california health insurance quote |
| california group health insurance quote |
| california health insurance online quote |
| state farm insurance quote |
| blue california health insurance quote shield |
| cheap health insurance quote |
| california health insurance life quote |
| online auto insurance quote houston |
| online auto insurance quote houston texas |
| life insurance policy quote |
| california cheap health insurance quote |
itd...
A u mysql helpu pise: "A leading plus sign indicates that this word must be present in each row that is returned"... a meni se u rezultatima ne pojavi rec 'car' nigde..
Ovo je verovatno zbog limita i toga sto boolean mode ne sortira rezultate po vaznosti (pa se neki delimicni match-evi nadju na vrhu liste), medjutim kako ja sad to da resim, jer meni trebaju samo i iskljucivo rezultati koji sadrze sve reci navedene u queriju ??? Jel ima neko neku ideju?