I have hundreds of posts whose titles are of the form
Y are natural numbers, for example
I'd like to replace
p in all post titles and slugs, while keeping
Y unchanged. How to do it in phpmyadmin?
UPDATE wp_posts SET post_title = REPLACE(post_title, 'm' , 'p') WHERE post_type = 'post' AND post_status = 'publish';
This code should replace in the titles, but what about the slugs?