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

Richard Bennett richard.bennett at skynet.be
Tue May 25 06:13:12 CDT 2004


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.



More information about the thelist mailing list