How To Use CONCAT In The 'FROM' Section

For example I'd like to use the following query:
SELECT * FROM CONCAT('table_', 'name');

Is there a way to do this? or something similar?