SHOW COLUMNS FROM table [ LIKE pattern ]
List the columns in a
table along with their data type and other attributes.
Specify a pattern in the optional
LIKE clause to
filter the results to the desired subset. For example, the following query
allows you to find columns ending in
SHOW COLUMNS FROM nation LIKE '%key'