DESCRIBE

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.