CREATE TABLE table_name_55 (date VARCHAR2, opponent VARCHAR2)

When is Northern Ireland the opponent?
SELECT date FROM table_name_55 WHERE opponent = "northern ireland"
SELECT "date" FROM "table_name_55" WHERE "northern ireland" = "opponent"