SQL Query to Title Select Images in a Given Album

[Brooklyn]

Similar to this question, how would I then batch name via SQL query a select portion of pictures within a given album? For example, I want to title only pictures xxx through yyy inside a given album, I assume using a PID statement, but cannot figure out how to implement that variable.

Any suggestions?

[Αndré]

http://dev.mysql.com/doc/refman/5.5/en/comparison-operators.html#operator_between

So you could use something like

Code Select Expand

UPDATE cpg15x_pictures SET title = 'new title' WHERE pid BETWEEN xxx AND yyy

[Brooklyn]

That'll do it, thanks again.