MySQL Full Text Search: Way to enable number search? (in form of text)


#1

Is there a way to let MySQL Full Text Search allow the search for numerical words, most particularly “two” and “three” and “five” ?

These three words are very important for certain searches on my site as I own a coin collecting site where people will often search for “two cent pieces”, “three cent pieces” or “five cent pieces”.

I understand that these are stop words in the MySQL Full Text system ( http://dev.mysql.com/doc/refman/5.5/en/fulltext-stopwords.html ). Is there any way Dreamhost can alter this file for me to include these three words or is there a way for me to do this?

Note: I have a normal shared account, not a private server.

Thanks


#2

We can’t change the search settings on a shared MySQL server, but we can on a MySQL VPS.