CREATE TABLE table_name_79 (result VARCHAR, competition VARCHAR, date VARCHAR)

Name the result for friendly competition on 9 october 2010
SELECT result FROM table_name_79 WHERE competition = "friendly" AND date = "9 october 2010"
SELECT "result" FROM "table_name_79" WHERE "9 october 2010" = "date" AND "competition" = "friendly"