CREATE TABLE table_225100_4 (vacator VARCHAR2, district VARCHAR2)

Who is the vacator when south carolina 4th is the district?
SELECT vacator FROM table_225100_4 WHERE district = "South Carolina 4th"
SELECT "vacator" FROM "table_225100_4" WHERE "South Carolina 4th" = "district"