extract most common words in row of database titles
Posted on 2008-11-03
I'm looking for an efficient solution to finding the most common words in a column of a database that comprises of text strings.
The solution would most likely be a combination of a mysql query and probably need some PHP to do some looping on results...
E.g. I have a table with 200,000 rows with a column for "titles" - these are names/titles of photos
I need a way to find the most common words in these 200,000 strings. This script need only run daily via a cron so it has room to be a little inefficient.