Mysql Fulltext Boolean Problem

[altendew]

Hi I currently have a problem..

I currently have my boolean limit set to 1 character in a word.

So if I search for e-Mail.. it will also bring up e-Gold..

Because of the "-" it does this, is there anyway to make it ignore that hyphen inside, and just return e-Mail??

 

[azzazzello]

can you post the query that's giving the problem please?

 

[altendew]

	$q = $db->Query('SELECT *, ((2*(MATCH(name) AGAINST (\''.$searchStr.'\' IN BOOLEAN MODE))) + (MATCH(answer, question) AGAINST (\''.$searchStr.'\' IN BOOLEAN MODE))) AS score FROM helpIcons WHERE MATCH(name, answer, question) AGAINST (\''.$searchStr.'\' IN BOOLEAN MODE) ORDER BY score DESC');