MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;

@@version

5.6.51

create table items(itemid int , itemname varchar(20));

insert into items value(1,"Temperature Outside");
insert into items value(2,"Temperature Inside");
create table item2(time int,value int);

insert into item2 value(1,58);
insert into item2 value(2,67);
insert into item2 value(3,25);
insert into item2 value(6,1);
select @var :=itemid from items where itemname='Temperature Inside';
set @sqltext := concat('select * from item',@var);
PREPARE stmt FROM @sqltext;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

@var :=itemid

2

Statement prepared

time
value

1
58

2
67

3
25

6
1