Anyone have experience with getting something expunged from record?

Please only those with direct experience or work in the field who knows what to do answer this question.

Long story short, my boyfriend and I got in a Stupid overdramatic fight (which seriously never happens. We were both drunk.. which also rarely happens) and cops came and took him away for the night until he sobered up and gave him “intoxication in public.” We are both mortified. He has court next week and he is going to hopefully expunge off his record. He has never been in trouble like this before and nor have I. We want it off his record. Do we have to get an attorney for something like that? Does he show up alone?

Advice please. Seriously can’t believe this happened .. it’s so out of the blue and out of character for us 🤦🏻‍♀️