Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Search Keywords Question  (Read 2326 times)

0 Members and 1 Guest are viewing this topic.

seanophobia

  • Coppermine newbie
  • Offline Offline
  • Posts: 18
Search Keywords Question
« 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...?
Logged

Nibbler

  • Guest
Re: Search Keywords Question
« Reply #1 on: June 12, 2005, 03:35:04 pm »

You can apply the keywords directly from the database using phpmyadmin.

Code: [Select]
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.
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 15 queries.