CREATE TABLE table_203_815 (id NUMBER, "pick #" NUMBER, "nfl team" CLOB, "player" CLOB, "position" CLOB, "college" CLOB)

who was the only player from kansas state ?
SELECT "player" FROM table_203_815 WHERE "college" = 'kansas state'
SELECT "player" FROM "table_203_815" WHERE "college" = 'kansas state'