Thank you for that clarification. I have my recordings stored in a folder tree residing in the "Videos" section. This allows me to arrange the recordings in a logical fashion, with multiple folder levels (i.e. nested folders). When I tried to do this with nested folders in "Recorded TV", the nested folders were ignored.Note that the query I proposed is only suitable for MySQL, and only addresses movement of files. It does not address clean-up only.
I am not sure what the original poster wants to do -- move recordings to another disk defined as a "Recorded TV" location, or move recordings to the "Videos" section. But whichever he wants, he should write the tool to satisfy his requirements, not mine!
-- from CyberSimian in the UK