How to use variable as table name in SELECT?

Question

MySQL

There is a need to generate a table name depending on the current time, it is formed like this:
"SELECT CONCAT('dbname.tableprefix',DATE_FORMAT(NOW(),'%Y%m')) INTO @tablename;"
Next, you need to execute the query "SELECT `somefield` FROM @tablename;"
MySQL (5.5.44) throws a syntax error.
How to use variable value as table name for query?

Answer 1

Found a solution.
SELECT CONCAT('dbname.tableprefix',DATE_FORMAT(NOW(),'%Y%m')) into @t;
SET @sqltext=concat('select `somefield` from ',@t);
PREPARE sel FROM @sqltext;
EXECUTE sel;
DEALLOCATE PREPARE sel;