17 lines
1.1 KiB
SQL
17 lines
1.1 KiB
SQL
SET NAMES utf8mb4;
|
||
SET CHARACTER SET utf8mb4;
|
||
|
||
UPDATE teams SET name = 'Condores VC' WHERE name IN ('Cóndores VC', 'Cóndores VC');
|
||
UPDATE teams SET coach_name = 'Julian Paz' WHERE coach_name IN ('Julián Paz', 'Julián Paz');
|
||
UPDATE teams SET name = 'Central Volley' WHERE name IN ('Central Vóley', 'Central Vóley');
|
||
UPDATE teams SET name = 'Atletico Red' WHERE name IN ('Atlético Red', 'Atlético Red');
|
||
UPDATE teams SET coach_name = 'Ramiro Lopez' WHERE coach_name IN ('Ramiro López', 'Ramiro López');
|
||
|
||
UPDATE players SET first_name = 'Sofia' WHERE first_name IN ('SofÃa', 'Sofía');
|
||
UPDATE players SET last_name = 'Benitez' WHERE last_name IN ('BenÃtez', 'Benítez');
|
||
UPDATE players SET first_name = 'Lucia' WHERE first_name IN ('LucÃa', 'Lucía');
|
||
UPDATE players SET first_name = 'Tomas' WHERE first_name IN ('Tomás', 'Tomás');
|
||
UPDATE players SET last_name = 'Diaz' WHERE last_name IN ('DÃaz', 'Díaz');
|
||
UPDATE players SET last_name = 'Gomez' WHERE last_name IN ('Gómez', 'Gómez');
|
||
UPDATE players SET first_name = 'Nicolas' WHERE first_name IN ('Nicolás', 'Nicolás');
|