idtstudios2
Programmer
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 other words if I were to use "fuzzy, bunny, animal" then I would want the 10 rows that have matching or "similar keywords".
I have no clue how do this so I am at a complete loss. Is there a function that would help? Any help would be great, thanks.
I need to be able to do a search for the top 10 rows that match a given set of tags/keywords. In other words if I were to use "fuzzy, bunny, animal" then I would want the 10 rows that have matching or "similar keywords".
I have no clue how do this so I am at a complete loss. Is there a function that would help? Any help would be great, thanks.