CREATE TABLE table_19179465_1 (bp VARCHAR, club VARCHAR)

What was the B.P. of club Halifax?
SELECT bp FROM table_19179465_1 WHERE club = "Halifax"
SELECT "bp" FROM "table_19179465_1" WHERE "Halifax" = "club"