There are many ways to do this here a couple:
1) You can use something like:
Better search and replace plugin here:
https://wordpress.org/plugins/better-search-replace/
or
SAFE SEARCH AND REPLACE ON DATABASE WITH SERIALIZED DATA script here: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/
Both of these with serialize the data, which is important for many themes and plugins.
There is a good explanation of WP Serialized data here:
https://wpengine.com/support/wordpress-serialized-data/