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 |
02. 06. 2009. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
Boolean full-text search
tabela izgleda ovako:
Kôd:
mysql> SELECT * FROM AssetKeywords; +----+----------+---------+ | id | asset_id | keyword | +----+----------+---------+ | 7 | 178 | more | | 8 | 180 | pera | | 6 | 190 | zika | +----+----------+---------+ Kôd:
SELECT * FROM AssetKeywords WHERE MATCH (keyword) AGAINST ('more' IN BOOLEAN MODE); Kôd:
SELECT * FROM AssetKeywords WHERE MATCH (keyword) AGAINST ('zika' IN BOOLEAN MODE); SELECT * FROM AssetKeywords WHERE MATCH (keyword) AGAINST ('pera' IN BOOLEAN MODE); najludje je sto sam probao na dve baze ( 5.0.51a-3ubuntu5.4 i 5.0.67-community), na dva razlicita servera, isto se desava ??? jel ima bilo ko kakvu ideju o cemu se radi?
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
|
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. 11:14 |
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. 09:29 |
full-text search se chudno ponasa | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 3 | 16. 11. 2007. 01:46 |
mysql full text search u boolean modu | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 1 | 11. 05. 2007. 21:59 |
Boolean search na innodb | cvele | SQL baze podataka - Sponzor: Baze-Podataka.net | 10 | 06. 12. 2006. 21:59 |