diff options
| author | emkael <emkael@tlen.pl> | 2016-10-05 12:07:02 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2016-10-05 12:07:02 +0200 |
| commit | dc803087fdd072595caf9da39998f79e035b2380 (patch) | |
| tree | 6988cc847f5423b0115510bdafd9ad902fd6bc91 /import | |
| parent | 3fbdfdaec46fafb21c39797f474d5c5fd761da81 (diff) | |
* http://ergast.com/mrd/bugs/#comment-15534
Diffstat (limited to 'import')
| -rw-r--r-- | import/10_fixes.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/import/10_fixes.sql b/import/10_fixes.sql index 6b04b4f..1335a55 100644 --- a/import/10_fixes.sql +++ b/import/10_fixes.sql @@ -191,3 +191,7 @@ UPDATE results SET number = 17 WHERE resultId = 19957; -- 1951 British Grand Pri UPDATE results SET number = 15 WHERE resultId = 19958; -- 1951 British Grand Prix, Murray UPDATE results SET number = 23 WHERE resultId = 19959; -- 1951 British Grand Prix, Chiron UPDATE results SET number = 16 WHERE resultId = 19960; -- 1951 British Grand Prix, James + +-- http://ergast.com/mrd/bugs/#comment-15534 +UPDATE races SET name = REPLACE(name, 'GP', 'Grand Prix') WHERE name LIKE '%GP%'; +UPDATE races SET name = REPLACE(name, 'Belgium', 'Belgian') WHERE `name` LIKE 'Belgium%'; |