[mythtv-users] How to bulk mark old recordings as watched?

[Christopher Kerr]

Hi everyone,

For a long time, my recordings weren't being marked watched, but it's
been behaving itself since the new year.

However, because the autoexpirer is set to expire Watched before
Unwatched, and most of my old recordings incorrectly appear Unwatched,
relatively recent recordings are being expired in preference to very
old ones.

What I need is a way to mark all but the most recent, say, 100
recordings as watched, so that expiration may resume sensibly.

I can imagine how I'd do it with SQL, but I thought I'd ask here first
in case I've missed something obvious.

- Chris