I gave a friend £3,000 when I was drunk - can I legally get it back?

A reader made a mistake when transferring a friend thousands of pounds - then sobered up and regretted it. But is he entitled to get the money back?