FULLTEXT stopword problem
Posted: Wed Nov 23, 2005 2:23 pm
Hey guys... happy thanksgiving!
I have a column in a table I want my visitors to perform fulltext searches on, however the contents of this column are model numbers like so:
Lp-233 Gold
Tz-100 Silver
Ma-100 Gold
Pe-500 Platinum
Most of my visitors will probably just want to search 'Lp-233' for example. The problem is '-' (hyphen) is a FULLTEXT stopword and because of this, no results are being returned. Is there a way to make '-' (hyphen) not a stopword?? Thanks for your help! Take care and happy holidays!
I have a column in a table I want my visitors to perform fulltext searches on, however the contents of this column are model numbers like so:
Lp-233 Gold
Tz-100 Silver
Ma-100 Gold
Pe-500 Platinum
Most of my visitors will probably just want to search 'Lp-233' for example. The problem is '-' (hyphen) is a FULLTEXT stopword and because of this, no results are being returned. Is there a way to make '-' (hyphen) not a stopword?? Thanks for your help! Take care and happy holidays!