How to bulk add text to mysql records at the beginning and at the end, wordpress site?

Question

MySQL

How to bulk add text to mysql records at the beginning and at the end? wordpress

Answer 1

update posts
set post_content = CONCAT('bla', post_content, 'bla-bla')
where post_type = 'your_post_type';

Answer 2

update wp_posts
set post_content = concat('content start', post_content, 'content end')
where post_type = 'post' or post_type = 'page' and post_status = 'publish'