help neeed statement

From: Darren Spooner (DarrenS_at_ihatespam.spacecamp.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 14:56:53 -0500

i need to create a union select statement with all tables that have 'Mail'
in the name of the table.
i will have an unknow number of tables (Mail, Mail1, Mail2, Mail3, .....)
how would i creat the statement?