Requête utilisant un CONCAT dans le from

 SELECT champ1, champ2
  FROM 
    (
      SELECT CONCAT('test_',entriesid) 
      FROM tabletest
      WHERE name = 'kb' 
      AND id = 3125
      )AS tbl;
      

 
 SELECT tbl.champ1, tbl.champ2
  FROM 
    (
      SELECT CONCAT('test_',entriesid) 
      FROM tabletest
      WHERE name = 'kb' 
      AND id = 3125
      )AS tbl;    
   

 SELECT max(tbl.nr)
  FROM 
    (
      SELECT CONCAT('test_',entriesid) , count(*) AS nr
      FROM tabletest
      WHERE name = 'kb' 
      AND id = 3125
      )AS tbl;

 SELECT tbl.champ1, tbl.champ2 (A)
  FROM 
    (
      SELECT CONCAT('test_',entriesid) 
      FROM tabletest
      WHERE name = 'kb' 
      AND id = 3125
      )AS tbl;

select id into @val_id from tabletest where name='kb' and id=3125;

set @table_name := CONCAT('Test_' , @val_id);
select @table_name;
PREPARE rp FROM @table_name;
EXECUTE rp;

DECLARE distinctCursor CURSOR for SELECT DISTINCT champ1, champ2 FROM @table_name;

select id into @val_id from tabletest where name='kb' and id=3125;
set @table_name := CONCAT('Test_' , @val_id);