[thelist] is there something like eval() in my sql?

[Richard Bennett]

Hi,

I am trying to open a table whose name can be variable, but am having trouble 
getting this to work:

SELECT * FROM CONCAT("table","Monday")
doesn't work.

SELECT * FROM tableMonday
works fine of course.

Ia there something like this ? :
SELECT * FROM EVAL(CONCAT("table","Monday"))


I'm trying to do this in SQL only, I realise it would be pretty easy from PHP 
or something.

Thanks,

Richard.