CREATE TABLE table_29085 ("Round #" CLOB, "Home Team" CLOB, "Win/Loss" CLOB, "Score" CLOB, "Opposition" CLOB, "Location" CLOB)

What is the location when the opposition is mid canterbury?
SELECT "Location" FROM table_29085 WHERE "Opposition" = 'Mid Canterbury'
SELECT "Location" FROM "table_29085" WHERE "Opposition" = 'Mid Canterbury'