CREATE TABLE table_42786 ("Tie no" CLOB, "Home team" CLOB, "Score" CLOB, "Away team" CLOB, "Attendance" CLOB)

What is the Tie no when the away team was Burnley?
SELECT "Tie no" FROM table_42786 WHERE "Away team" = 'burnley'
SELECT "Tie no" FROM "table_42786" WHERE "Away team" = 'burnley'