Bug #7608 enhancement request for Show columns
Submitted: 1 Jan 2005 16:38 Modified: 2 Jan 2005 12:03
Reporter: Phillip Hamilton-Wilks Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:3.23.58 OS:gnu-linux
Assigned to: CPU Architecture:Any

[1 Jan 2005 16:38] Phillip Hamilton-Wilks 
Description:
When I use "show columns from table..", mysql returns the columns from the table as expected.
I however work with some tables that have over a hundred columns.
I know I can limit the columns by name using "show columns from table like '%Aggr%' but I would like to be able to limit the by the type. For example "show columns from table where type like date".

How to repeat:
na
[2 Jan 2005 12:03] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

You can do it in 5.0.4