View Single Post
Old July 31st, 2004, 01:53 PM   #2
Chuck S
Photopost Developer
Verified Customer
Chuck S's Avatar
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,926
The only way to mass edit the database is through the mysql replace command where you do a search on a field and replace all keywords with something else.

Now I would be very careful when doing this and backup your database before doing this

UPDATE pp_photos SET keywords = REPLACE(keywords, 'oldkeyword','newkeyword');

Note I used pp_ as the prefix you may need to change it.
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote