[Resolved] Selecting the tables in the database?

[vitalyb]

MySQL: I'd like to get a list (using a SELECT) of all the tables in the database, how do I do it?

[laserlight]

maybe could run a
SHOW TABLES
query and loop through the results.