Menu
Hey, I have a nutritional database that I need to search from. One of the problems I’m having is with names like “McDonald’s” because many users spell it like “McDonalds” (plural instead of possesive).
I would like to know if there is a way to have a search for McDonalds (plural) match the possesive version as well. Ideally a MySQL solution, but I’m guessing I’ll have to use PHP to identify plural words and search for both cases. Btw, I have a full-text index on the food description field which has entries like “McDonald’s Cheeseburger”.