need help in the update query
The task can be solved using dynamic SQL. Something like:

CREATE PROCEDURE assing_value(propertyname TEXT, blueprintid BIGINT)
BEGIN
SELECT CONCAT('UPDATE t_ci SET s39=', column_name, ' WHERE blueprint_id=', blueprintid)
  INTO @sql
  FROM t_core_properties
  WHERE property_name=propertyname;
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE stmt;
END;


and then

CALL assing_value('Virtual IP Address', 1234);




or the same in plain code:

SET @column := ( SELECT column_name 
                 FROM `t_core_properties` 
                 WHERE property_name='Virtual IP Address');
SET @sql := CONCAT('UPDATE t_ci SET s39=', 
                    @column, 
                   ' WHERE blueprint_id IN (',
                   ' SELECT id',
                   ' FROM `t_core_blueprints`', 
                   ' WHERE NAME=\'VMWare VCenter\')');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE stmt;