CREATE TABLE table_5059 ("Date" CLOB, "City" CLOB, "Opponent" CLOB, "Results\\u00b9" CLOB, "Type of game" CLOB)

When is Northern Ireland the opponent?
SELECT "Date" FROM table_5059 WHERE "Opponent" = 'northern ireland'
SELECT "Date" FROM "table_5059" WHERE "Opponent" = 'northern ireland'