Automate MYSQL concatenate within Wordpress blogs and content fields

IN PROGRESS
Bids
10
Avg Bid (USD)
$90
Project Budget (USD)
$30 - $100

Project Description:
I’m looking for a script that will populate the content field in a Wordpress database with information from a separate table.

There will be a large number of Wordpress blogs each with hundreds of records so the script will have to be very efficient. The plan is to run the script at regular intervals using a cron process on the server.

The Wordpress database will have the default configuration but I would like to then add an additional field to it that is a flag to show the content has been updated.

The source database has content in a BLOB format so it would have to be uncompressed then appended to the content in the Wordpress database. Within that content I will also want to attach an extra text string. (essentially I want to concatenate Wordpress content, static text string, incoming BLOB content) There will be two IDs that are referenced (blog ID and post ID) to match the selections. Also a check will need to be done where if the BLOB field is empty the process will skip over that record.

Once this process has completed then the flag will be set to show that content has been updated and when the script runs again it will not repopulate the content.

I’ve already created some MYSQL statements to do this process but don’t know how to automate it across all of the blogs and records which is why I need your help.

If interested please bid. If any questions feel free to ask.

Additional Project Description:
05/06/2013 at 19:20 AKDT
Note: This project is NOT for a Wordpress plugin. It is for a script that runs within MYSQL. The only reason I mentioned Wordpress was because that is what the source table is. But in reality Wordpress skills are not needed for this task.

Skills required:
Linux, MySQL, Wordpress
Hire fpena
Project posted by:
fpena United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 103
in 2 days
$ 100
in 2 days
Hire zeke
$ 103
in 1 days
$ 50
in 14 days
Hire bigdognec
$ 100
in 3 days
$ 105
in 3 days
Hire stevensow
$ 100
in 2 days
Hire rahulsng1
$ 66
in 3 days
$ 88
in 1 days
$ 88
in 3 days