Globally replacing photo tags?

[taylorpiano]

Is there a way for me to globally search and replace some of the tags I have been giving our photos?

Here is my reason. Every time one of our members win Photo of the Week, I tag the forums post announcing the winners with potw-username. Then I go to the photo that won on the PP side and give it a key word potw-username.

For those that won POTW 2nd place, I decided to just give the key word 2nd-Place.
Later I realized I should have named them POTW-2nd-Place, so I could separate the 2nd place winners for Photo of the Month, Quarter, Year.

If I could do a search and replace of the 282 now keyworded photos, then just go back and change the 40 POTM 2nd place winners by hand, it would save me tons of time

Crossing my fingers this is somehow possible xxx

[Chuck S]

ALL Depends you need to be careful as it will replace all so you want to be EXACT to find results and also to replace them with the proper words.

UPDATE pp_photos SET keywords='keywords' WHERE keywords='keywords';

[taylorpiano]

thanks, I'll have Steve take a look at it. Its the only place I gave key words like that so we should be ok.
Trying to do little things like this before we do the big upgrade to vB4.1 that we are working on now.

[Chuck S]

okay no problem