SHOW FIELDS, but with a filter by field type?

Question

I have a mySQL database with multiple tables with many fields.

Is there any own way to find only fields of type TEXT ?

I know how to do this using a scripting language such as PHP. I just want to know if there is a trick using SHOW TABLES / SHOW FIELDS. I dont know.

Answer 1

For MySQL 5+, you can query INFORMATION_SCHEMA :

 SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE DATA_TYPE = 'TEXT';