Replace Unwanted Space in Post Content URL

I think you should run this query. To replace space with dash.

update wp_posts set wp_posts.post_name = REPLACE( wp_posts.post_name, ' ', '-' );

Don’t forget to change table_prefix in this.
And also, keep a backup on current database before trying.

Related Posts:

  1. Clean up very big and very dirty database
  2. How can I convert everything from category X to have post format Link
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  5. SQL WITH clause example [duplicate]
  6. The wait operation timed out. ASP
  7. Conversion failed when converting date and/or time from character string while inserting datetime
  8. how to fix oracle ORA-01722 invalid number error
  9. SQL query to select dates between two dates
  10. MySQL – Operand should contain 1 column(s)
  11. SQL SELECT WHERE field contains words
  12. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  13. NOT IN vs NOT EXISTS
  14. Must declare the scalar variable
  15. ORA-00979 not a group by expression
  16. How can I do a FULL OUTER JOIN in MySQL?
  17. MySQL query String contains
  18. T-SQL split string based on delimiter
  19. Finding duplicate values in a SQL table
  20. MySQL Cannot Add Foreign Key Constraint
  21. Oracle error : ORA-00905: Missing keyword
  22. How do I import an SQL file using the command line in MySQL?
  23. mysql Foreign key constraint is incorrectly formed error
  24. Can a foreign key be NULL and/or duplicate?
  25. How do composite indexes work?
  26. Difference between JOIN and INNER JOIN
  27. MySQL “WITH” clause
  28. What is the difference between JOIN and UNION?
  29. MySQL Multiple Joins in one query?
  30. Error Code: 2013. Lost connection to MySQL server during query
  31. “CASE” statement within “WHERE” clause in SQL Server 2008
  32. SQL join on multiple columns in same tables
  33. ORA-00972 identifier is too long alias column name
  34. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  35. Sql query – getting rid of hard-coded values
  36. ORA-00918: column ambiguously defined in SELECT *
  37. How To Run A Github Repository?
  38. SQL Switch/Case in ‘where’ clause
  39. Oracle – ORA-01489: result of string concatenation is too long [duplicate]
  40. SQL Server WITH statement
  41. How to run a SQL query on an Excel table?
  42. Algebra Relational sql GROUP BY SORT BY ORDER BY
  43. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  44. Remote table-Valued Function Calls are not allowed
  45. The backend version is not supported to design database diagrams or tables
  46. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  47. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  48. Difference between View and table in sql
  49. Using group by on multiple columns
  50. What is the purpose of using WHERE 1=1 in SQL statements?
  51. Exclude a column using SELECT * [except columnA] FROM tableA?
  52. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  53. pg_ctl: no database directory specified and environment variable PGDATA unset
  54. ERROR 1148: The used command is not allowed with this MySQL version
  55. Bulk load data conversion error (truncation)
  56. How to order by with union in SQL?
  57. Difference between INNER JOIN and LEFT SEMI JOIN
  58. SQL conditional SELECT
  59. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  60. PostgreSQL create table if not exists
  61. PostgreSQL visual interface similar to phpMyAdmin?
  62. DATEDIFF function in Oracle
  63. Solutions for INSERT OR UPDATE on SQL Server
  64. MySQL – Get row number on select
  65. MySQL error: Unknown column in ‘where clause’
  66. What is the difference between Views and Materialized Views in Oracle?
  67. How to truncate the text returned for a column in a MySQL query
  68. “select * into table” Will it work for inserting data into existing table
  69. ORA-01735: invalid ALTER TABLE option – Toad
  70. CASE IN statement with multiple values
  71. List of special characters for SQL LIKE clause
  72. What SQL Query to do a simple find and replace
  73. Use wpdb->prepare for `order by` column name
  74. How To Write An Inner Join With WP Query
  75. Cron While Editing Post
  76. Include data from custom table in WP_Query
  77. How to import a Typo3 database to a wordpress site?
  78. find pods item where relationship to other pod is not set
  79. cleaning up safely wordpress wp_postmeta table
  80. Export SQL query based on post type
  81. Convert a category of posts to a custom post type using (MySQL) queries
  82. Connect to Ms SQL Server
  83. wpdb prepare sql problem
  84. Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
  85. REGEXP_REPLACE in post_contet
  86. Menu Order updating automatically
  87. How delete post_content records of specific category from phpmyadmin
  88. Reset post IDs with all post meta
  89. Fastest way to display 5000 post titles?
  90. How to Add or Change Post Title
  91. Why does DROP TABLE-ing the `wp_options` reset my user session?
  92. How do I display SQL query on a specific page of my wordpress site
  93. How to refactor DB queries for better TTFB in WordPress?
  94. How to process a single attribute in a SQL request twice times?
  95. query sql-table and change entities
  96. Is it possible to utilize custom SQL for a single-post.php?
  97. How to handle my row actions on a custom list table in the admin section
  98. Backtick (MySQL norm) added to SQL Server Query causing error
  99. How can I avoid duplicate primary keys in SQL import?
  100. Has the table name in SQL for WordPress changed from WP_posts to WPCS_post?
tech