In the system that I am putting together, the dashboard of adm shows the total number of requests, which are created for each user and within them, the requests are recorded by the tables.
Ex: User 75, has its db pedidos_75
and inside has the tables with the IDs of each request.
The question is, can you make a selection of databases and count how many have with the name starting with pedidos
, as if it were a SHOW TABLES LIKE "pedidos%"
and count
?