CREATE TABLE table_name_47 (opponent VARCHAR, date VARCHAR)

Who was the opponent of the match on 2006-04-08?
SELECT opponent FROM table_name_47 WHERE date = "2006-04-08"
SELECT "opponent" FROM "table_name_47" WHERE "2006-04-08" = "date"