CREATE TABLE table_name_41 (player VARCHAR, to_club VARCHAR)

What player was moved to Blackpool?
SELECT player FROM table_name_41 WHERE to_club = "blackpool"
SELECT "player" FROM "table_name_41" WHERE "blackpool" = "to_club"