coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: seanophobia on June 11, 2005, 07:53:49 PM

Title: Search Keywords Question
Post by: seanophobia on June 11, 2005, 07:53:49 PM
Is there any way to add search keywords to all pictures in a album, because i wish to add the same keywords to all the files in the album, but going through and adding to each pic is improbably when many of my albums have 1000+ pics...?
Title: Re: Search Keywords Question
Post by: Nibbler on June 12, 2005, 03:35:04 PM
You can apply the keywords directly from the database using phpmyadmin.

UPDATE cpg_pictures SET keywords = CONCAT(`keywords`, ' yournewkeyword') WHERE aid = 123

Use the prefix you chose during installation instead of cpg_ and the album number you want to update instead of 123. Backup your pics table beforehand.