[MYSQL] elenco tabelle senza prefisso

[lanciafiamme]

select replace(table_name,'tax','') from information_schema.tables
where (table_schema='nomedeldatabase')
and (table_name like 'tax%')