summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2016-10-05 12:07:02 +0200
committeremkael <emkael@tlen.pl>2016-10-05 12:07:02 +0200
commitdc803087fdd072595caf9da39998f79e035b2380 (patch)
tree6988cc847f5423b0115510bdafd9ad902fd6bc91
parent3fbdfdaec46fafb21c39797f474d5c5fd761da81 (diff)
* http://ergast.com/mrd/bugs/#comment-15534
-rw-r--r--import/10_fixes.sql4
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%';