I need to select NOT all columns in the request to display the status of the tables. Now it looks like this:

SHOW TABLE STATUS IN `myTableName` WHERE `NAME` LIKE '%name_substring%';

How to modify it to achieve the desired effect and is it possible at all?

    1 answer 1

    Use to get the information you need:

     SELECT * FROM information_schema.tables WHERE table_schema = 'db_name' AND table_name = 'table_name';

    Here you can already specify only the required columns.

    • a small mistake is not information_schema.table, but information_schema.tables And so everything is super. Thank! - srgg67