UPDATE wp_posts SET post_content = replace( post_content,'t.expdu.com','uat-ren.sitelab.com.au') ;
UPDATE wp_comments SET comment_content = replace(comment_content,'t.expdu.com','uat-ren.sitelab.com.au') ;
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 't.expdu.com', 'uat-ren.sitelab.com.au') ;
UPDATE wp_postmeta SET `meta_value` = replace(meta_value,'t.expdu.com','uat-ren.sitelab.com.au') ;
UPDATE wp_options SET `option_value` = replace(option_value, 't.expdu.com', 'uat-ren.sitelab.com.au') ;
UPDATE wp_posts SET post_content = replace( post_content,'127.0.0.16','uat-ren.sitelab.com.au/peng') ;
UPDATE wp_comments SET comment_content = replace(comment_content,'127.0.0.16','uat-ren.sitelab.com.au/peng') ;
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, '127.0.0.16', 'uat-ren.sitelab.com.au/peng') ;
UPDATE wp_postmeta SET `meta_value` = replace(meta_value,'127.0.0.16','uat-ren.sitelab.com.au/peng') ;
UPDATE wp_options SET `option_value` = replace(option_value, '127.0.0.16', 'uat-ren.sitelab.com.au/peng') ;