How do I change several broken URLs in a several wordpress databases in the fastest way?
I tried and searched but not yet achieved.
I have a 167 wordpress websites on my host and for almost every website the logo URL is broken (pointing to an unavailable IP address).
I found the right table in the database under wp_options and tried to change the URL removing the wrong IP this way
But this doesn’t work, leading to no images in the header.
I am trying to find a way to solve this problem editing the database or using the CLI so I can do that in loop and not doing it manually through the backend for every site.
Sorry for my english, non-native speaker here.