antenna

Hi our box sits on the floor under the sofa so gets moved regularly when hovering. Tonight the connector gave way. It had been loose for a while, I thought it was a loose screw and when I went to check it I finally broke it off, flush with the box. How do I fit a new antenna in?