[VelvetKevorkian]

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

Any nod to the right direction is appreciated.

[scott967]

I would guess something along the lines of:

Code:

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

scott s.
.

[VelvetKevorkian]

that worked, thank you very much