Public feed #889311

Vermischtes

public text v1 · immutable
Raw Edit
·published 2008-02-02 20:54 UTC
rendered paste body
SET @FieldNumber = 35;
SELECT CONCAT_WS(' ',
(SELECT SUBSTRING_INDEX(`data`, ' ', (SELECT @FieldNumber) - 1) FROM `character` WHERE name LIKE '%mijster'),
NULL,
(SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', (SELECT @FieldNumber)), ' ', -1) FROM `character` WHERE name LIKE '%mijster'),
NULL,
(SELECT SUBSTRING_INDEX( `data` , (SELECT SUBSTRING_INDEX( `data` , ' ', (SELECT @FieldNumber)) FROM `character` WHERE name LIKE '%mijster' ) , -1) FROM `character` WHERE name LIKE '%mijster')
)


to do:
1. select -> update
2. fester ausdruck '%mijster' in variable speichern
3. angabe des neuen werts in variable und query
4. alles sorgfältig überprüfen (!)