Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO ', REPLACE(table_name,'ts_','life_'),';' ) FROM information_schema.tables Where table_name LIKE 'ts_%';