[es] - Koriscenje full text pretrage sa wildcards-ima

NikolaVeber
NikolaVeber
neradnik na porodiljskom bolovanju
Karlsruhe

Član broj: 5115
Poruke: 1254
*.rz.uni-karlsruhe.de

Jabber: nikolaveber@jabber.org
ICQ: 121532865

Profil

Koriscenje full text pretrage sa wildcards-ima - da li je moguce?

^{28.05.2004. u 09:30 - pre 242 meseci}

Pozdrav!

Kao sto naslov rece, zanima me da li je moguce da mysql-ov full text search za trezeni string vraca i reci koje taj string sadrze?

Code:

"SELECT *, MATCH ( $parameters ) AGAINST ('$begriff') AS score FROM $tabelle WHERE MATCH ( $parameters ) AGAINST ('$begriff') ORDER BY score DESC";

$parameters su polja nad kojima se vrsi pretraga, $begriff je trazeni izraz.

Kada imam, na primer, vrednost 123test456, da li je moguce da se trazi "test" iz sredine?

Probao sam sa wildcards, tj
$begriff = "%".$input["0"]."%";
ali zeljeni rezultat nisam postigao.

Da li je uopste moguce ovo o cemu govorim?

Pop Servis "Paradise Tours"
Java User Group Karlsruhe
IT Dan - Srbija

Officer, I saw the driver who hit me - his name was Johnny Walker.

Odgovor na temu

Dejan Topalovic
Dejan Topalović
Senior Oracle DBA & Senior PL/SQL
Developer, Erste Sparinvest (Erste
Bank), Vienna, Austria
Vienna

Član broj: 635
Poruke: 1374
*.1.14.vie.surfer.at

Sajt: www.baze-podataka.net

+2 Profil

Re: Koriscenje full text pretrage sa wildcards-ima - da li je moguce?

^{28.05.2004. u 12:38 - pre 242 meseci}

Mozes da koristis wildcards, ali ne da koristis % nego *.
Dakle, *test* bi trebalo da ti nadje sve rijeci u kojima se nalazi test:
test123, 123test123 i td.

"SELECT *, MATCH ( $parameters ) AGAINST ('*$begriff*') AS score FROM $tabelle"

Blog - baze podataka
---------------------
Oracle OCP DBA (9i & 10g)
Oracle Database: SQL Certified Expert
Oracle OCP Developer
Certified MySQL DBA

Odgovor na temu

NikolaVeber
NikolaVeber
neradnik na porodiljskom bolovanju
Karlsruhe

Član broj: 5115
Poruke: 1254
*.rz.uni-karlsruhe.de

Jabber: nikolaveber@jabber.org
ICQ: 121532865

Profil

Re: Koriscenje full text pretrage sa wildcards-ima - da li je moguce?

^{28.05.2004. u 12:54 - pre 242 meseci}

Code:

SELECT *, MATCH ( autor, titel, untertitel, auflage, isbn ) AGAINST ('*sfasdfaFulltextsdfafasdf*')
AS score FROM buecher WHERE MATCH ( autor, titel, untertitel, auflage, isbn ) AGAINST
('*sfasdfaFulltextsdfafasdf*') ORDER BY score DESC

vraca jedan red u kome jedno polje ima vrednost 'sfasdfaFulltextsdfafasdf'.

Code:

SELECT *, MATCH ( autor, titel, untertitel, auflage, isbn ) AGAINST ('*Fulltext*') AS score
FROM buecher WHERE MATCH ( autor, titel, untertitel, auflage, isbn ) AGAINST ('*Fulltext*')
ORDER BY score DESC

Ne vraca nista.

btw, "MySQL 4.0.16-log running on localhost"

Pop Servis "Paradise Tours"
Java User Group Karlsruhe
IT Dan - Srbija

Officer, I saw the driver who hit me - his name was Johnny Walker.

Odgovor na temu