Plural Searching With Match Against + REGXP

[tommyda]

I am building a search function using the following code:

$results = mysql_query("SELECT * , MATCH(name,description,keywords,manufacturerid)
                                   AGAINST('+$search' IN BOOLEAN MODE) AS score FROM products WHERE MATCH(name,description,keywords,manufacturerid)
                                   AGAINST('+$search' IN BOOLEAN MODE) AND imageurl !='' ORDER BY score DESC")or die(mysql_error());

 

The problem I am having is that im getting more results when I search for the word "table" than I am for the plural "tables"

 

I would preferably like to display both results for the plural and single variations of each keyword searched.

 

I read on another forum that this can be solved using REGEXP but i have no idea how to implement it.

 

Any help would be much appreciated.

 

Thanks

[fenway]

Well, you'll always get partial matches with fulltext searching... personally, I don't see anything wrong with that.