# Remove "marked as read" from database

**URL:** <https://forums.plex.tv/t/remove-marked-as-read-from-database/310974>\
**Category:** General Discussions\
**Created:** [September 21, 2018, 10:32pm UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974 "2018-09-21T22:32:16Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaulThePlexLover](https://avatars.discourse-cdn.com/v4/letter/p/cc9497/32.png) [@PaulThePlexLover](https://forums.plex.tv/u/PaulThePlexLover)\
**Post date:** [September 21, 2018, 10:32pm UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/1 "2018-09-21T22:32:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [September 21, 2018, 11:25pm UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/2 "2018-09-21T23:25:56Z")

</div>

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`):

 ![](https://sea1.discourse-cdn.com/plex/uploads/default/original/3X/c/5/c59296dde906a0359a010a7f282781c2dbaf6abc.png)

![](https://sea1.discourse-cdn.com/plex/uploads/default/original/3X/6/4/647482f5cdb7e53390d9fd4f9e09b1f97367a730.png)

---

<div class="post-metadata">

**Author:** ![anon18523487](https://avatars.discourse-cdn.com/v4/letter/a/49beb7/32.png) [@anon18523487](https://forums.plex.tv/u/anon18523487)\
**Post date:** [September 22, 2018, 9:13am UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/3 "2018-09-22T09:13:58Z")

</div>

DELETE \* from metadata\_item\_settings;

That will nuke the entire table that tracks that info.

---

<div class="post-metadata">

**Author:** ![PaulThePlexLover](https://avatars.discourse-cdn.com/v4/letter/p/cc9497/32.png) [@PaulThePlexLover](https://forums.plex.tv/u/PaulThePlexLover)\
**Post date:** [September 22, 2018, 2:17pm UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/4 "2018-09-22T14:17:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tom80H](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/tom80h/32/19753_2.png) [@tom80H](https://forums.plex.tv/u/tom80H)\
**Post date:** [September 23, 2018, 12:55am UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/5 "2018-09-23T00:55:43Z")

</div>

should be `DELETE FROM metadata_item_settings;`

---

<div class="post-metadata">

**Author:** ![PaulThePlexLover](https://avatars.discourse-cdn.com/v4/letter/p/cc9497/32.png) [@PaulThePlexLover](https://forums.plex.tv/u/PaulThePlexLover)\
**Post date:** [September 23, 2018, 1:25am UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/6 "2018-09-23T01:25:39Z")

</div>

Thanks, guys. Really appreciate it.

Paul

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [December 22, 2018, 1:25am UTC](https://forums.plex.tv/t/remove-marked-as-read-from-database/310974/7 "2018-12-22T01:25:41Z")

</div>

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