Drinking suddenly makes me nauseous (probably psychosomatic), how do I fix this?

Last weekend I accidentally drank too much and did something kind of stupid and had a hangover which made me feel ill and since then, alcohol or even sometimes just the thought of drinking has generally made me feel nauseous. Will this go away if I’m sober for awhile? I don’t like it