How to Add Many Titles at Once

[apanda]

Hi.  I am moving a 2000 photo collection to Coppermine.  Is there an efficient way to add Titles to the photos all at once? 

I  can make a table of filenames and Titles.  Can I get this into the database some quick way?  Perhaps I can figure out SQL and do it that way, but maybe there's a better way than that.  Someone please let me know.

Andrew

[apanda]

I did some more searching and found Ralf's reply.  He suggests using SQL like this:

Update cpg_pictures
  SET title = x
  WHERE aid = y

I will try that unless I see a better solution here soon.  Thanks for reading.  Thanks, Ralf, for your answer.

Andrew