How to list MySQL tables whose name starts with base?

Question

PHP

Tables of the form are dynamically created in the database:
base1
base2
base3
base4... You
need to get a list of these tables and the number of records in them.
If everything is clear with the query by the number of records, then how should the MySQL query for getting tables with a name starting with "base" look like.
Thanks in advance.

Answer 1

Regular SELECT ... WHERE query from information_schema.tables

Answer 2

If such crutches have already gone that you can’t put everything in one database, then choosing a cycle is the very thing.