is there a way to find and replace in wordpress?

There’s a plug-in that can facilitate that process for you, but you have to be careful when using it (make sure you run a complete back-up of your system first), as it runs the search and replace directly on the database.

I’ve used it once or twice and it’s worked beautifully for me. Good luck.