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

NikolaVeber
neradnik na porodiljskom bolovanju
Karlsruhe

Član broj: 5115
Poruke: 1250
*.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}

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?

blog.sun.com/srbija
Java User Group Karlsruhe
Studiranje u Nemačkoj

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

^{28.05.2004. u 09:30}

Dejan Topalovic
Dejan Topalović
Oracle DBA & PL/SQL Developer, Erste Sparinvest (..
Vienna

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

ICQ: 20142302
Sajt: www.outsourcing-it.com

Profil

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

^{28.05.2004. u 12:38}

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 - Database thingies
---------------------
Oracle OCP DBA
Oracle OCP Developer
Certified MySQL DBA

^{28.05.2004. u 12:38}

NikolaVeber
neradnik na porodiljskom bolovanju
Karlsruhe

Član broj: 5115
Poruke: 1250
*.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}

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"

blog.sun.com/srbija
Java User Group Karlsruhe
Studiranje u Nemačkoj

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

^{28.05.2004. u 12:54}