sql to update the image files on bulk after a CSV upload of dogs. The image files must match the url_title of the dog which, by default is the same as the dog's name but in lowercase

gistfile1.sql

UPDATE exp_channel_data cd 
        INNER JOIN exp_channel_titles ct
             ON cd.entry_id = ct.entry_id
SET cd.field_id_9 = CONCAT('{filedir_2}', ct.url_title, '.jpg')
WHERE ct.channel_id = '2'