CREATE TABLE table_50215 ("Date" CLOB, "Opponent" CLOB, "Venue" CLOB, "Result" CLOB, "Attendance" CLOB, "Competition" CLOB, "Man of the Match" CLOB)

Who was the Opponent when Terry Miles was the Man of the Match?
SELECT "Opponent" FROM table_50215 WHERE "Man of the Match" = 'terry miles'
SELECT "Opponent" FROM "table_50215" WHERE "Man of the Match" = 'terry miles'