Text only | Text with Images

coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: Brooklyn on April 17, 2012, 04:47:04 AM

Title: SQL Query to Title or Re-Title all Images in a Given Album
Post by: Brooklyn on April 17, 2012, 04:47:04 AM
If I wanted to run a query to title all uploaded images in a given album to the same phrase, what would the proper SQL query be?
Title: Re: SQL Query to Title or Re-Title all Images in a Given Album
Post by: Αndré on April 17, 2012, 11:34:03 AM
Code Select
UPDATE cpg15x_pictures SET title = 'new title' WHERE aid = '<enter album ID here>'
Title: Re: SQL Query to Title or Re-Title all Images in a Given Album
Post by: Brooklyn on April 17, 2012, 02:36:35 PM
Perfect, thank you.

Would this work for the descriptions as well?

Code Select

UPDATE cpg15x_pictures SET caption = 'new description' WHERE aid = 'Album ID';
Title: Re: SQL Query to Title or Re-Title all Images in a Given Album
Post by: Brooklyn on April 17, 2012, 02:44:52 PM
It does. Solved.
Text only | Text with Images