Can you select multiple tables with the beginning of the name the same?

2

On the base base_suporte , there are the tables with the user token and the support token suporte_tokenUser_tokenSup . On the general support page, all media need to appear, this part is complete and working.

But in the client part, what opened the support, how the tables of each support has the different end, can make a selection of suporte_tokenUser to get all tables with the user token equal? >

Ex:

User Token is 78 and the support token is 45246 , so the name of the table will be suporte_78_45246 .

In the user pane with token 78, you need to show all tables that correspond with the beginning suporte_78 or suporte_78_ . How?

    
asked by anonymous 23.12.2017 / 04:32

1 answer

3

Yes, you can filter the names of tables by passing a certain term. To do this, just use the query SHOW TABLES / p>

SHOW TABLES LIKE "suporte_78%"
    
23.12.2017 / 08:03