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

http://x.x.x.x/wp-contents/logo.png 

Became

.png

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.