Batch change media attachment display settings?

I have a WP site with hundreds of images contained within the posts. I wanted to use Lightbox on my site, but after trying three different lightbox plugins, and none working, I realised this is probably to do with the ‘ATTACHMENT DISPLAY SETTINGS’ in all the images being set to ‘none’
I understand they have to link to the ‘media file’ in order for lightbox to work properly?

so my questions is, how can ‘batch’ change the attachment link settings for all of my sites images to media file, without going through hundreds, one by one?

is there a way?

Thanks