CREATE TABLE table_80120 ("Team" TEXT, "Manager" TEXT, "Captain" TEXT, "Kit manufacturer" TEXT, "Shirt sponsor" TEXT)

Which team does David O'leary manage?
SELECT "Team" FROM table_80120 WHERE "Manager" = 'david o''leary'
SELECT "Team" FROM "table_80120" WHERE "Manager" = 'david o\'leary'