Bulk Move using MySql Statements/Queries Directly

[mihirp]

Assuming that I want to globally move all the photos which have the words "xyz" in their title, can I use MySql Commands directly to move/update the database rather than use bulk actions and change categories for the same manually which is too time consuming and slow.

For ex: If I want to move all the photos which have the exact word "Nice Photo" in title to cat 158, I would use the following command

update pp_photos set cat = '518' where title = 'Nice Photo';

Similarly, if I want to update the cat values for LIKE type keywords, then I would use the foll:

update pp_photos set cat = '518' where title like '%keyword%';

Of course I would not blindly just run these commands, I would first run the select * from pp_photos where title = 'Nice Photo'; and the other LIKE command to check out the results it shows, so I can decide whether they include only those ones which I want to move/update. If not I would use more specific commands.

I can say that I am pretty proficient with MySql, so that should not be a problem.

I just want to ask whether this would lead to any problems if I do it manually. The only thing would be that it would not auto send email alerts to the image posters that their images have been moved.

Please let me know.

[Chuck S]

You can not use sql statements alone to change where photos are located because the same resulting action of actually moving the physical photo needs to be done also so you must use the bulk or approve photo displays in admin

[mihirp]

Oh yes, I forgot that part. How about adding a new feature in Admin to Search for Photos based on keywords and move them together. This would be a very very helpful feature and I had also posted this earlier.

Thanks for your reply, Chuck.