Vermischtes

eine alternative wird noch in verbindung mit php erstellt.....
--------------------------------------------------------------

UPDATE 
   `characters`.`character`
SET
   `data` = 
   (
      SELECT CONCAT_WS(' ',
         (SELECT 
            SUBSTRING_INDEX(`data`, ' ', (SELECT @INDEX))
         FROM
            `character`
         WHERE
            guid = (SELECT @GUID)),
         NULL,
         (SELECT @NEWVALUE),
         NULL,
         (SELECT 
            SUBSTRING_INDEX( `data`, (SELECT SUBSTRING_INDEX( `data` , ' ', (SELECT @INDEX) + 1) FROM `character` WHERE guid = (SELECT @GUID)), -1)
         FROM
            `character`
         WHERE
            guid = (SELECT @GUID))
      )
   )
WHERE
   `character`.`guid` = (SELECT @GUID)
LIMIT 
   1;