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

[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é]

Code Select Expand

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?

Code Select Expand


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


[Brooklyn]

It does. Solved.