I've got a wordpress site, it's curently have about about 3000 released posts, the issue is i wish to perform a personalization towards the released publish instantly.

For instance, i've got a released publish:

title: "ABC LCD Monitor"
content: "ABC LCD Monitor is an extremely popular product, bla bla bla."

And i wish to edit to

title: "ABC LCD Monitor"
content:
"Thanks for visiting the [title] page."
"This is actually the review about [title]:"
"[original publish]"
"Purchase it now!"

You can observe the [title] is changed through the publish title, and also the [original publish] is changed through the previous content from the publish:

"ABC LCD Monitor is an extremely popular product, bla bla bla."

Is easy to do and just how ?

attempt to run sql cmd in mysql database:

UPDATE wp_posts SET post_content = concat('Welcome to the ',post_title, ' page.This is the review about ',post_title, ':<br />', post_content,'<br />Buy it now!')