mysql replace wp prefix

gistfile1.txt

SELECT * FROM `stage_options` WHERE `option_name` LIKE '%wp_%';

RENAME TABLE stage_commentmeta to c2g_commentmeta;  
RENAME TABLE stage_comments to c2g_comments;  
RENAME TABLE stage_duplicator_packages to c2g_duplicator_packages;  
RENAME TABLE stage_links to c2g_links;  
RENAME TABLE stage_nf_objectmeta to c2g_nf_objectmeta;  
RENAME TABLE stage_nf_objects to c2g_nf_objects;  
RENAME TABLE stage_nf_relationships to c2g_nf_relationships;  
RENAME TABLE stage_ninja_forms_fav_fields to c2g_ninja_forms_fav_fields;  
RENAME TABLE stage_ninja_forms_fields to c2g_ninja_forms_fields;  
RENAME TABLE stage_options to c2g_options;  
RENAME TABLE stage_postmeta to c2g_postmeta;  
RENAME TABLE stage_posts to c2g_posts;  
RENAME TABLE stage_social_users to c2g_social_users;  
RENAME TABLE stage_termmeta to c2g_termmeta;  
RENAME TABLE stage_terms to c2g_terms;  
RENAME TABLE stage_term_relationships to c2g_term_relationships;  
RENAME TABLE stage_term_taxonomy to c2g_term_taxonomy;  
RENAME TABLE stage_usermeta to c2g_usermeta;  
RENAME TABLE stage_users to c2g_users;  
RENAME TABLE stage_wc_osmeta to c2g_wc_osmeta;  
RENAME TABLE stage_woocommerce_api_keys to c2g_woocommerce_api_keys;  
RENAME TABLE stage_woocommerce_attribute_taxonomies to c2g_woocommerce_attribute_taxonomies;  
RENAME TABLE stage_woocommerce_downloadable_product_permissions to c2g_woocommerce_downloadable_product_permissions;  
RENAME TABLE stage_woocommerce_order_itemmeta to c2g_woocommerce_order_itemmeta;  
RENAME TABLE stage_woocommerce_order_items to c2g_woocommerce_order_items;  
RENAME TABLE stage_woocommerce_order_status_action to c2g_woocommerce_order_status_action;  
RENAME TABLE stage_woocommerce_sessions to c2g_woocommerce_sessions;  
RENAME TABLE stage_woocommerce_tax_rates to c2g_woocommerce_tax_rates;  
RENAME TABLE stage_woocommerce_tax_rate_locations to c2g_woocommerce_tax_rate_locations;  
RENAME TABLE stage_woocommerce_termmeta to c2g_woocommerce_termmeta;