mysql批量删除表名为某前缀的表

mysql> drop table like 'qibo_%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like 'qibo_%'' at line 1
mysql> show tables where table_name like 'qb_%';
ERROR 1054 (42S22): Unknown column 'table_name' in 'where clause'
mysql> select concat('drop table ', TABLE_NAME, ';') from information_schema.`tables` where TABLE_NAME like 'qb_%';
+----------------------------------------+
| concat('drop table ', TABLE_NAME, ';') |
+----------------------------------------+
| drop table qb_ad_compete_place;        |
| drop table qb_ad_compete_user;         |
| drop table qb_ad_config;               |
| drop table qb_ad_norm_place;           |
...
+----------------------------------------+
156 rows in set (0.03 sec)

参考：
https://fukun.org/archives/07051222.html