mysql - Select specific columns by SHOW TABLE STAUS query -

mysql - Select specific columns by SHOW TABLE STAUS query -

i have select specific columns show table status query. looks like:

show table status in `mytablename` `name` '%name_substring%';

...and returns columns. there way reach goal?

you can query information_schema.tables in order specific columns. check demo: http://sqlfiddle.com/#!2/38506/3

select * information_schema.tables table_name = 'mytablename';

hope helps

mysql table status