Bulk Move using MySql Statements/Queries Directly
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.