Change userrating in KODI db using DB Browser?

Change userrating in KODI db using DB Browser? - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Music Support (https://forum.kodi.tv/forumdisplay.php?fid=263)
+--- Thread: Change userrating in KODI db using DB Browser? (/showthread.php?tid=313004)

Change userrating in KODI db using DB Browser? - VelvetKevorkian - 2017-04-23

Hi,

i don't know much about SQL, but i've been able to edit my db using this guide and the replace function:
http://kodi.wiki/view/HOW-TO:Update_SQL_databases_when_files_move

I now want to change every song with a userrating of 2 to a 0, to make them unrated.

How can i achieve that Huh

Any nod to the right direction is appreciated.

RE: Change userrating in KODI db using DB Browser? - scott967 - 2017-04-24

I would guess something along the lines of:

Code:
UPDATE "main"."song" SET userrating="0" WHERE userrating="2"

scott s.
.

RE: Change userrating in KODI db using DB Browser? - VelvetKevorkian - 2017-04-24

that worked, thank you very much Smile