Bug #3748 SHOW *NOT* LIKE/SHOW LIKE x AND/OR LIKE y
Submitted: 13 May 2004 18:34 Modified: 5 Dec 2005 11:52
Reporter: Michael Winston Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:any OS:Any (any)
Assigned to: CPU Architecture:Any

[13 May 2004 18:34] Michael Winston 
Description:
I'd like to see the syntax:
SHOW COLUMNS FROM tbl_name NOT LIKE 'pattern' AND NOT LIKE 'otherpattern'
for all SHOW commands.  It would be a nice, friendly way to filter out a subset.  Also would be 
consistent with SELECT syntax.

Just an idea.

How to repeat:
Feature request.  Nothing to repeat.
[5 Dec 2005 11:52] Valeriy Kravchuk 
Thank you for a feature request. I do not think, though, that SHOW statements will be extended in such a ways. You can use INFORMATION_SCHEMA in MySQL 5 to get the descriptions of columns from any tables you like. Read http://dev.mysql.com/doc/refman/5.0/en/columns-table.html for the details.