I have many tables that begin with "cir_" and for me, the MySQL command to select all of them is:
show tables like "cir%";
I took the above answers and modified them and it worked! Woohoo!