Hey guys and girls
I have a DB related problem.
Is use the following SQL string:
select PID, MATCH (Fnaam, Vnaam, mail) AGAINST('$Against' IN BOOLEAN MODE) as score
from Perso where MATCH (Fnaam, Vnaam, mail) AGAINST('$Against' IN BOOLEAN MODE)
If i do this:
$Against = "Winte";
or
$Against = "Winrs";
And search the DB i get a person called Winters in return.
BUT if i do this:
$Against = "*inters";
I don't get a match!!! How come? It comes down to the fact that i can't start a word i'm searching for with a *. Can i get around this problem, is this a bug? All help is welcome.
TIA
