CREATE TABLE table_24765815_1 (player VARCHAR2, opponent VARCHAR2)

Which player had an opponent of Blackburn Rovers?
SELECT player FROM table_24765815_1 WHERE opponent = "Blackburn Rovers"
SELECT "player" FROM "table_24765815_1" WHERE "Blackburn Rovers" = "opponent"