如何确保每个playerid拥有至少1张主图像，如果他有超过0张图像（mysql）

I'm working with the images table. I need to make sure each player has a primary image if he has more than 1 image. In the following example dataset, this would update either myimage.jpg or hisimage.jpg's primary to 1 and only1image.jpg's primary to 1. I'm working with the images table. I need to ma