Tag: WordPress

Change a line across a bunch of posts in WordPress

To change a line can  in posts across many in WordPress, can manually be a “pain-in-the-ass”-task. But can actually be done quite easily with a single line of MySQL-code, executed from the db-admin-interface (phpmyadmin etc.) UPDATE wp_posts SET post_content=REPLACE(post_content, ‘text-to-be-replaced’, ‘text-to-insert’) To be more understandable, you use it like this UPDATE Table-Name SET Field-Name=REPLACE(Field-Name, ‘Text-To-Be-Replaced’, ‘Text-To-Insert’); With this…

Read the full article