CREATE TABLE table_name_42 (home_team VARCHAR(255), away_team VARCHAR(255))
What home team played Collingwood as the away team?
    
SQL: SELECT home_team FROM table_name_42 WHERE away_team = "collingwood"