| Old Version - SQL Help on pruning pix.
Hi,
I'm using 3.3.1, I know you will tell me to u/g. Our site interface was a real pain to integrate in to 3.3.1 so for now, we're keeping it.
I need to prune out a LOT of pix by this criteria:
Pix older than 6 months with no comments.
I have an idea for removing the files once I can get the query to work.
What I'm asking for is a way to update the database and set the 3 image (width, height, size) size fields to 0 where the date is older than 3 months and there are no comments. My issue is that the comments are in another table and I am VERY rusty on the old SQL.
Once I can zero those fields, I will bulk move the pix to a temp category and delete all of the files that were left over from the original folder location.
The help I am seeking is how to perform an SQL command that does that.
Thanks for your assistance. No, there is not a prune images feature in the version of PP that I am using.
Cheers,
Adam
| 
Linear Mode
