Created
September 2, 2013 14:12
-
-
Save 1stevengrant/6413309 to your computer and use it in GitHub Desktop.
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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment