Вы можете использовать ниже -
SET @qry = CONCAT('SELECT ',@SHIFTIME,' INTO @SHIFTSELECT FROM `oee_machinenames` where `oee_machinenames`.`ID` = New.NAME'); PREPARE stmt FROM @qry; EXECUTE stmt; DEALLOCATE PREPARE stmt;