MySQL 8.0

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

Create table measurem(mmID int,placeName varchar(50));
insert into measurem values(1,'Some name');
Select @my_name :='Some name';

@my_name :='Some name'

Some name

Select @id;

@id

null

Select mm.mmID From measurem as mm where mm.placeName=@my_name

mmID

1

    SET @s = CONCAT('Select mm.mmID into @id From measurem as mm where mm.placeName=','''',@my_name ,'''');
    PREPARE stmt FROM @s;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
Select @id;

@id

1