How to replace specific words in multiple wordpress post titles at once?

Question

There are some outdated plugins. But those are not seem to be useful and not actually working.

There are 2000 post titles and I want to bulk edit/replace specific word from them. How can I do this by using mysql command?

Like this : Changing Sloppy to Ronn in 2000 wordpress post titles at once. How can I do that?

Originally it was written by Frank Bueltge, awesome developer, nowadays his company is behind it: https://wordpress.org/plugins/search-and-replace/ It does the job for sure — brasofilo, May 20 '18 at 00:37

score 0 · Accepted Answer · edited May 19 '18 at 21:21

0

otherwise try running this command:

UPDATE table_name 
   SET field_name = replace(field_name, 'string_to_change', 'new_string')

edited May 19 '18 at 21:21

Strawberry

answered May 19 '18 at 18:29

Matias Miraglio

with that command, it will only change the titles of posts, right? Because I only want to replace some words in 2000 titles. – Fixiywp May 19 '18 at 19:14
yes. You have to replace table_name with your table's name and field_name with the field name used for the title. I think it is "post_title " or something similar. – Matias Miraglio May 19 '18 at 19:22
Yes it worked. Can you also give the command for post texts? I also want to change some texts inside of posts and moreover urls. Will be appreciated. – Fixiywp May 20 '18 at 16:11

1 Answers1