variable table names in queries ...

[C.R. Vegelin]

Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried 
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable;
but this doen't work. Is there any way to work around this ?
Thanks, Cor