Replace a character in all post titles and slugs

Slugs are saved in the very same table but in the post_name column. So your query would look like this:

UPDATE wp_posts
SET post_name = 
REPLACE(post_name, 'm' , 'p')
WHERE post_type="post" AND post_status="publish";

By the way, I’d suggest you to use $wpdb->posts instead of just wp_posts ( then it would be compatible with different prefixes, but it’s not important if it’s just a “local” script )

Related Posts:

  1. How to bulk edit canonical url’s in SQL?
  2. Cannot add or update a child row: a foreign key constraint fails
  3. Cannot add or update a child row: a foreign key constraint fails
  4. How to make MySQL table primary key auto increment with some prefix
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  7. Rename a column in MySQL
  8. Syntax error due to using a reserved word as a table or column name in MySQL
  9. MySQL root password change
  10. Installation of MySQL for Visual Studio 1.2.8 failed
  11. Not unique table/alias
  12. How do I import an SQL file using the command line in MySQL?
  13. Install mysql-python (Windows)
  14. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  15. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  16. SQL Query Where Field DOES NOT Contain $x
  17. Disable ONLY_FULL_GROUP_BY
  18. MySQL WHERE IN ()
  19. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  20. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  21. difference between primary key and unique key
  22. Mysql command not found in OS X 10.7
  23. MySQL – UPDATE query based on SELECT Query
  24. How to export a mysql database using Command Prompt?
  25. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  26. MySQL Error #1133 – Can’t find any matching row in the user table
  27. How can I prevent SQL injection in PHP?
  28. Best way to store an array in MySQL database?
  29. How do I change the data type for a column in MySQL?
  30. MySQL date formats – difficulty Inserting a date
  31. Cannot connect to Database server (mysql workbench)
  32. How to grant remote access permissions to mysql server for user?
  33. How to check if mysql database exists
  34. #1062 – Duplicate entry for key ‘PRIMARY’
  35. How can I convert a string to a float in mysql?
  36. Is there a Profiler equivalent for MySql?
  37. How to use greater than operator with date?
  38. How to properly create composite primary keys – MYSQL
  39. How to replace the domain name in a WordPress database?
  40. Optimize WordPress Query that take 5 seconds to execute
  41. MySQL Replication Latency Issues in wp-admin pages
  42. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  43. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  44. Increment value (value = value+1) of $wpdb->update
  45. How can I debug my database connection for unit testing?
  46. Extending the database
  47. SQL query not working in alphabetical post title/content search
  48. Universal problem: first request after ~25 second inactivity always slower (~1 second) than subsequent requests (~1/10sec)
  49. How to do a MySQL dump from production site without using a search and replace script for local development?
  50. Importing MariaDB into Mysql in WordPress
  51. Concurrent / simultaneous MySQL connections
  52. How to check for empty and not a failure
  53. How to get a Google maps SQL->XML->map marker tutorial to work in WordPress
  54. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  55. Converting mysql to $wpdb
  56. Update a WordPress post or page takes 60+ seconds
  57. Bulk activate a theme on multisite
  58. add_post_meta does not respect the content
  59. Modify MySQL Query Based on Dropdown Menu
  60. Select multiple wp_postmeta keys with single select
  61. Deprecated: mysql_connect():
  62. Backing up and restoring multiple sites efficiently
  63. $wpdb select all meta for each post
  64. Alter wp_post table vs. post_meta performance/speed
  65. Replacing link URL ending strings via MySQL
  66. Are these WordPress tables safe to add indexes to?
  67. Is it possible to create a WordPress table using array and loop?
  68. SQL syntax error when getting data for a url
  69. How to stop $wpdb from prepending database name
  70. Import CSV to MySQL, with custom registration field information
  71. Locally restoring a ManageWP full site backup
  72. WordPress doesn’t save changes some times
  73. Getting Error Trying to Create Table
  74. Best approach for a custom database filling in WP custom post types
  75. Why doesn’t custom mysql query return results? Is syntax correct?
  76. Insert two row in wordpress database
  77. SQL statement using placeholder is not returning results
  78. How to Bulk find and replace MySQL for post image url
  79. Wpdb query with dynamic table name
  80. How to search usermeta table
  81. Regular XML-RPC timeouts
  82. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  83. update multiple rows in mysqli table base on two values
  84. I want to share local developement and staging DB — Is this very smart or very stupid?
  85. How can I verify WordPress nonce from the following code?
  86. How to write in MySQL more characters in user_nicename
  87. $wpdb->get_var not returning count
  88. Custom user query – orderby meta_key (that may not exist)
  89. How to get Attachments(image) with specific width\height ratio
  90. What is the cron doing?
  91. Apache Redirect based on WordPress permissions
  92. SQL error on restoring database
  93. MySQL database gives blank page (white screen of death)
  94. Datatabase error: Commands out of sync
  95. why is $wpdb->update() causing a DB error from within wp_set_password()
  96. Global MySQL replacing of text patterns/matches
  97. WP_Query with LIKE returns strange query
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?