- -- 搜索应急相关表 + 用户指定的表
- SELECT table_name FROM information_schema.tables
- WHERE table_schema = 'slaj'
- AND (table_name LIKE 't_busi%' OR table_name LIKE '%eme%' OR table_name LIKE '%emgc%' OR table_name LIKE '%emerge%'
- OR table_name LIKE '%drill%' OR table_name LIKE '%conplan%' OR table_name LIKE '%supplies%'
- OR table_name LIKE '%team_info%' OR table_name LIKE '%train_record%' OR table_name LIKE '%insure%')
- ORDER BY table_name;
|