CREATE TABLE table_78865 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Date" CLOB)

minehead has what tie number?
SELECT "Tie no" FROM table_78865 WHERE "Home team" = 'minehead'
SELECT "Tie no" FROM "table_78865" WHERE "Home team" = 'minehead'