WordPress Mysql query updation for server

UPDATE [your_table_name] SET [your_table_field] = REPLACE([your_table_field], ‘[string_to_find]’ , ‘[string_to_be_replaced]’);

e.g:

UPDATE wp_posts SET guid = REPLACE( guid, ‘http://localhost/yourproject’,’http://yourdomain.com’ ) ;
UPDATE wp_posts SET post_content = REPLACE( post_content, ”http://localhost/yourproject’, ”http://yourdomain.com’ ) ;
UPDATE wp_options SET option_value = REPLACE( option_value, ”http://localhost/yourproject’, ‘http://yourdomain.com’ ) ;

000000
It's only fair to share...