CREATE TABLE table_31848 ("Pick #" FLOAT, "MLS Team" CLOB, "Player" CLOB, "Position" CLOB, "Affiliation" CLOB)

What MLS team is affiliated with yale university?
SELECT "MLS Team" FROM table_31848 WHERE "Affiliation" = 'yale university'
SELECT "MLS Team" FROM "table_31848" WHERE "Affiliation" = 'yale university'