DESCRIBE
DESCRIBE table_name {field_name | wildcard}
DESCRIBE returns the definition of the specified table and fields (the same as SHOW COLUMNS FROM table_name).The wildcard can be part of the fieldname and can be a percentage sign (%), meaning a number of characters, or an underscore (_), meaning one character.