|
SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
|
11. 05. 2007. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
mysql full text search u boolean modu
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; 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... 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?
__________________
Leadership is the art of getting people to want to do what you know must be done. |
11. 05. 2007. | #2 |
Nekad bio ddz
Expert
|
Za sortiranje po relevantnosti probaj
Kôd:
select ovo, ono, match (kolona) against ('+bla +trucj +nja' in boolean mode) as score from tabela where match (kolona) against ('+bla +trucj +nja' in boolean mode) order by score desc
__________________
Converting dead links into hyperlinks since 1996. |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
relevantnost mysql full text searcha | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 13 | 29. 04. 2010. 12:14 |
Boolean full-text search | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 4 | 03. 06. 2009. 02:35 |
Sphinx Free open-source SQL full-text search engine - problem sa našim slovima | pcigre | SQL baze podataka - Sponzor: Baze-Podataka.net | 9 | 01. 04. 2008. 10:29 |
full-text search se chudno ponasa | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 3 | 16. 11. 2007. 02:46 |
Boolean search na innodb | cvele | SQL baze podataka - Sponzor: Baze-Podataka.net | 10 | 06. 12. 2006. 22:59 |