Bulk add keywords via PhpMyadmin?

[Daethian]

I don't know much about editing tables but I know it can be done.  I have one set of keywords I would like to add to an entire album. Instead of doing it through the gallery itself it seems like it would go faster to use PhpMyAdmin and insert.  Is this possible and would someone be willing to help me with the proper syntax for accomplishing this? My SQL version: 4.1.22-standard

[Nibbler]

If you don't have any existing keywords then use

Code Select Expand

UPDATE cpg_pictures SET keywords = 'foo' WHERE aid = 123;

If you want to add to a set of existing keywords use

Code Select Expand

UPDATE cpg_pictures SET keywords = CONCAT(keywords, ' ', 'foo') WHERE aid = 123;

Change cpg to the prefix you use, foo to the keywords (space separated) and 123 to the album number.

[Daethian]

Thanks so much! I'll give it a shot

[Daethian]

It worked!! Thanks again so much you have made my life so much easier!!!  *happy dance*