Selecting tables in a mysql

[HansNeven]

I want to make a report based on a selection from a MySQL table schema where de table name consist a specific name the first part of the namen consist de date name. I want to combine these tables to 1 database.

 In MYSQL I have the following SQL.

SELECT * FROM information_schema.tables WHERE TABLE_NAME LIKE '%specname' AND table_schema ='lhb-tdc_dag' AND table_rows <> 0

[Icey · Accepted solution]

Hi @HansNeven ,

Is this problem solved?

Best Regards,

Icey

[az38]

Hi @HansNeven 

you can write this statement in the Advanced Settings of Get Data -> Mysql dialog box