Find and replace text using phpMyAdmin, handy when migrating a site

Use the SQL tab in phpMyAdmin allows you to find and replace text in each table in the database. This is especially handy when migrating a WordPress website from a development server to a live domain.

SQL Query

UPDATE `wp_table` SET `post_content` = replace( post_content , 'http://text_needs_to_be_replaced' , 'replacement_text_new_url')