Kodi Community Forum

Full Version: Change userrating in KODI db using DB Browser?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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_...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.
I would guess something along the lines of:
Code:
UPDATE "main"."song" SET userrating="0" WHERE userrating="2"

scott s.
.
that worked, thank you very much Smile