SQL Query to Title or Re-Title all Images in a Given Album SQL Query to Title or Re-Title all Images in a Given Album
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

SQL Query to Title or Re-Title all Images in a Given Album

Started by Brooklyn, April 17, 2012, 04:47:04 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Brooklyn

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?

Αndré

UPDATE cpg15x_pictures SET title = 'new title' WHERE aid = '<enter album ID here>'

Brooklyn

Perfect, thank you.

Would this work for the descriptions as well?


UPDATE cpg15x_pictures SET caption = 'new description' WHERE aid = 'Album ID';