CREATE TABLE table_26847237_3 (location VARCHAR2, opposition VARCHAR2)

What is the location when the opposition is mid canterbury?
SELECT location FROM table_26847237_3 WHERE opposition = "Mid Canterbury"
SELECT "location" FROM "table_26847237_3" WHERE "Mid Canterbury" = "opposition"