Remove "marked as read" from database

General Discussions
1

I would like for Plex to forget about everything I’ve watched before. In other word, mark everything in the library (and anything added later) as as unwatched. I know I can rub out the database, but is there a more surgical approach?

Thanks,
Paul

2

Maybe not your preferred choice… but what about using Plex Web, filter by watched items and toggle the ‘played’ status?

Filtering requires to use a custom filter (Unwatched: is false):

mceclip7-3.png873×226 165 KB

1 Like
3

DELETE * from metadata_item_settings;

That will nuke the entire table that tracks that info.

4

Thanks! I think that’s what I’m looking for, but I may be calling it wrong.

sqlite3 com.plexapp.plugins.library.db “DELETE * from metadata_item_settings;”
Error: near “*”: syntax error

5

should be DELETE FROM metadata_item_settings;

6

Thanks, guys. Really appreciate it.

Paul

7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.