Automate MYSQL concatenate within Wordpress blogs and content fields

In Progress

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.

Skills: Linux, MySQL, WordPress

See more: free mysql server, content in blogs, blogs that need help, wordpress server configuration, wordpress content, wordpress configuration, show the content, concatenate, automate], set within, mysql populate table, mysql add record, check table mysql script, mysql help table, script automate, wordpress post format, automate number, populate table using, mysql empty database, cron mysql, cron wordpress, attach database using, blogs need content, wordpress content format, bid process wordpress

Project ID: #4496588

Awarded to:

baptistepernet

Hello, I work on several relational databases on my life: Oracle, PostgreSQL and of course MySQL. I think I can help you for your project. Please check my profile and contact me.

$88 USD in 3 days
(1 Review)
2.6

10 freelancers are bidding on average $90 for this job

linuxfreak1985

Hi there, i am very interested to complete this project. please see my past reviews related to system administration lets complete this project

$103 USD in 2 days
(157 Reviews)
6.8
SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$100 USD in 2 days
(63 Reviews)
6.8
zeke

Available to start immediately and finish as soon as possible.

$103 USD in 1 day
(53 Reviews)
6.0
pablotorres

i can do it

$50 USD in 14 days
(54 Reviews)
5.2
bigdognec

I have a basic understanding of your project and ready to start

$100 USD in 3 days
(40 Reviews)
5.0
raiseit

Dear Sir, We are interested to work for you.Please check your private message.

$105 USD in 3 days
(11 Reviews)
4.7
stevensow

Thanks & Best Regards, Sow

$100 USD in 2 days
(11 Reviews)
4.1
rahulsng1

Hi, I can help you on this

$66 USD in 3 days
(20 Reviews)
4.2
lfr2

I have strong knowledge in php, mysql. I'm competent, reliable and efficient coder. Please check pmb.

$88 USD in 1 day
(14 Reviews)
3.7