Reply to thread

thanks fforde, but there's a lot of big bold writing nowadays warning that restoring old config might cause problems, so i was wary.

anyway, here's the sql in case it's of use to anyone else:

update user_movie_settings

set watched = 1

where id in (

select movie_info_id

from local_media__movie_info

where local_media_id in (

select id

from local_media

where fullpath like '%+%'))

cheers,

dh.