SELECT

a.*,

concat(

'alter table ',

a.TABLE_NAME,

' rename ge_',

SUBSTR(

a.TABLE_NAME

FROM

INSTR(a.TABLE_NAME, '_') + 1

),

';'

)

FROM

information_schema.`TABLES` a

WHERE

a.TABLE_SCHEMA = 'geekweb';