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;