CREATE TABLE table_31997 ("Year" FLOAT, "Competition" CLOB, "Date" CLOB, "Location" CLOB, "Score" CLOB, "Result" CLOB)

Tell me the result for harrogate
SELECT "Result" FROM table_31997 WHERE "Location" = 'harrogate'
SELECT "Result" FROM "table_31997" WHERE "Location" = 'harrogate'