phpmyadmin Question posted in
The official documentation can be found here.

Moved site , all links got corrupted, need correct SQL query to fix – Phpmyadmin

WordPress. from litespeed to ngix server.

All of my links to plugins, images CSS and scripts added "%20" on the end. Example:

https://example.com%20/wp-content/plugins/wp-maintenance-mode/assets/css/style.min.css?

I assume the solution would be to change all "example.com%20" to "example.com" in the database. What would be the correct query to put in phpmyadmin?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Found the solution, was a trailing space in wp-config.


  2. 0

    I assume the solution would be to change all "example%20" to "example" in the database.

    You can use replace():

    update t
    set link = replace(link, 'example%20', 'example')
    where link like '%example$%20%' escape '$';

    You have to be a little careful if 'example%20' were ever in the data before the change (i.e. is correct). However, that is unlikely in this case.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search