SHOW COLUMNS displays information about the columns in a given table (It also works for views as of MySQL 5.0.1).
The LIKE clause, if present, indicates which column names to match.
The WHERE clause can be given to select rows using more general conditions.

SHOW COLUMNS FROM <tablename>