How top retrieve COMMENT out of MySQL?

[Emanuele Dolis]

I know that i could use SHOW FULL COLUMNS FROM tb_drvset;
the fact is that I'd like to create a table out of it in order to do something like
SELECT Field, Type, Comment FROM sometable;.
I haven't got a clue of where mysql stores table information...

The option i've now is teeing the console into a file x, issuing the show full comuns, open file x, clean the file , importing back to MySQL into a newly defined table.

Pretty clumsy :(

Anyone gots good suggestion?

Thanks
emanuele