[SOLVED] MATCH / AGAINS non exact match?! (not fulltext error :P)

[thryb]

Hey guys,

Im having a litle problem with a query, I was reading about searching in multiple field with non exact match and the query should look like this in FULLTEXT

 

$sql = "SELECT * FROM Comment WHERE MATCH(CommSubject, CommText, PartCountry, PartCity)  AGAINST ('".$searchstring."') ORDER BY CommDT DESC";

 

The thing is I dont want the user to use boolean expression is the look for lets say

Sold

insteed of

Soldier

 

but if I try it with only sold, I get no query result. Does anyone have an idea what is wrong with it ?

 

Thanks in advance.

[thryb]

Sorry I found it, just had to use boolean but add my own operator ... duh.

 

$sql = "SELECT * FROM Comment WHERE MATCH(CommSubject, CommText, PartCountry, PartCity)  AGAINST ('*".$searchstring."*' IN BOOLEAN MODE) ORDER BY CommDT DESC";