Нашёл решение.
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;