Select data from “show tables” MySQL query March 26, 2023 by Tarik I think you want SELECT * FROM INFORMATION_SCHEMA.TABLES See http://dev.mysql.com/doc/refman/5.0/en/tables-table.html