For instance I run command

mysql> show tables;

Tables in DB

a

b

c

d

I want to use it such as concat('drop table ', tablename, ';');

So that my result set would become

drop table a;

drop table b;

drop table c;

and so on....