CREATE TABLE table_name_42 (player VARCHAR(255), country VARCHAR(255))
Which player is from Northern Ireland?
    
SQL: SELECT player FROM table_name_42 WHERE country = "northern ireland"