1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
UPDATE characters
SET data = CONCAT(
SUBSTRING_INDEX(data,' ',225+1),
' 1 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',315+1),' ',225-315),
' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',621+1),' ',315-621),
' 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',822+1),' ',621-822),
' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1319+1),' ',822-1319),
' 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1351+1),' ',1319-1351),
' 0 ',
SUBSTRING_INDEX(SUBSTRING_INDEX(data,' ',1447+1),' ',1351-1447),
' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ',
SUBSTRING_INDEX(data,' ',-1449+1447+1)
)
WHERE SUBSTRING_INDEX(data,' ',1448)=data;
|
