Change Prefix to MODX in MySQL

changeprefix.sql

/* Drop MODX */
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) 
    AS statement FROM information_schema.TABLES WHERE table_schema = 'instance_cXXXX_modx' AND table_name LIKE 'modx_%';
    
/* Change incorrect prefix */
SELECT CONCAT( 'RENAME TABLE ', TABLE_NAME, ' TO ', replace(TABLE_NAME, 'wrong_', 'modx_'), ';') 
    AS statement FROM information_schema.TABLES WHERE table_schema = 'instance_cXXXX_modx' AND table_name LIKE 'wrong_%';