In a mysql database I've got a column for images.
It's just the image name without the file extension eg 'xyz' and I want to add '.jpg' to the names to get 'xyz.jpg'.
I'm working directly with the database in phpmyadmin and I can't find the sql to do this. Anyone give me a clue?
