要使用LIKE运算符显示特定的表名称,语法如下-select table_name as `anyAliasName`
from information_schema.tables
where table_name like ‘yourValue%';
让我们实现以上语法,以使用LIKE运算符显示特定的表名:mysql> select table_name as `DemoTable1600`
-> from information_schema.tables
-> where table_name like 'DemoTable160_%';
这将产生以下输出+---------------+
| DemoTable1600 |
+---------------+
| demotable1600 |
| demotable1601 |
| demotable1602 |
| demotable1603 |
| demotable1604 |
| demotable1605 |
| demotable1606 |
| demotable1607 |
+---------------+
8 rows in set (0.01 sec)