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.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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';