This level of effort is to write a PHP script that can be run via a cron job, that will:
* Iterate through a MySQL column of type TEXT
* Parse out keywords from the each record and set type
* Insert the results from into a new table with these fields: id from original table (id), keyword, type (i.e., keyword, activity)
Note that the pattern of th...
Skills: mysql programming, php