CREATE TABLE table_name_26 (opponent VARCHAR, date VARCHAR)

What opponent played on 07-09-2012?
SELECT opponent FROM table_name_26 WHERE date = "07-09-2012"
SELECT "opponent" FROM "table_name_26" WHERE "07-09-2012" = "date"