Kodi

SQL

Update movies as watched

UPDATE files SET playCount = 1, lastPlayed = '2012-03-04 12:34:56' 
WHERE idPath IN (
  SELECT idPath from PATH WHERE strPath LIKE '%done/%'
)