Change Existing Image link type

Apologies in advance if this is in the wrong section.

All my existing images currently point to the post url. I want to change it to link to the image file directly. There are about 500 images in the blog thus changing it manually is going to be a nightmare.

Is there away this can be done automatically via a sql query or the likes?

Thanks

D.