What is the location when the opposition is mid canterbury?
CREATE TABLE "2009" (
  "round_num" text,
  "home_team" text,
  "win_loss" text,
  "score" text,
  "opposition" text,
  "location" text
);
SELECT "location" FROM "2009" WHERE "opposition"='Mid Canterbury';