mirror of
https://bitbucket.org/theswgsource/src-1.2.git
synced 2026-07-14 00:01:30 -04:00
7 lines
300 B
SQL
7 lines
300 B
SQL
UPDATE players SET uc_character_name = SUBSTR(LOWER(character_full_name), 1, INSTR(character_full_name || ' ', ' ', 1)-1)
|
|
WHERE character_object IN
|
|
(SELECT character_object
|
|
FROM players
|
|
WHERE uc_character_name != SUBSTR(LOWER(character_full_name), 1, INSTR(character_full_name || ' ', ' ', 1)-1) )
|
|
|