I'm not new to SQL or PHP, or basic queries of SQL databases, but I'm creating a site that's going to be dependent on having a really accurate search feature. Basically, I'm just looking for some help on how I can get started, because there's a ton of information out there (various downloads that claim to index databases and such) but it's all very confusing as I don't know exactly what I'm looking for.
I'm going to have a table with information about people (let's say that the columns include "profession," "name," and "location"), and I want a user to be able to search for either of these three values separately (let's say there's a separate search bar to search each of those columns). I just need a really good way for the user to be able to search for these values, where it would be able to suggest searches and fix spelling errors (like Google), but also match "Jim" for "Jimmy" and "NYC" for "N.Y.C." or "New York City."
I really appreciate any tips you might have. I'm just very confused by all the information that's available and have always really been thankful for all the advice given on this site! Thanks so much and have a great day!