I have MySQL table that has a field called "tags" that contains tags/keywords in the following format: "boston, blog, political". Now this table has about 30,000 to 40,000 rows on any given day.
I need to be able to do a search for the top 10 rows that match a given set of tags/keywords. In...