I have a classifieds site in which i would like to show the relevant ads in an ad post. I want to build a MySql query what will return all relevant ads for a specific keyword checking all the data in my MySql database. I had used MATCH() AGAINST() but could not get much accurate results. What should be the best method to build a query to get more accurate and relevant results for a specific keystring. Keystring may have many words in it. Thanks for any one who suggest a best method for me.
A couple of things to consider are spelling and omitting words. People spell things incorrectly (I do all the time). So if your search process only looks for exact matches then you might not be returning relevant results. In one database that I've got, I've got a table with alternate spellings that I use in searches. Omitting words is not searching for common words such as "the", "and", "is", etc. I've got a table of words to ignore that I use to omit words from the searches. Good luck.