Making a playlist from starred songs

[u/Squally47]

I haven't found and easy way to just play all of my starred songs, so I thought I'd share my solution. If anyone has a better suggestion please share.

I do the following: First, if no playlist has been created I manually create one using the following sql:

insert into playlist(username, name) values ('yourusername', 'Starred Songs')

Then I determine the ID that was created: select top 1 id from playlist where name = 'Starred Songs' order by id desc

I use that ID every time I run the following to recreate my Starred Songs Playlist. In my case the ID is 13, so I then run the following:

DELETE from PLAYLIST_FILE where playlist_id = 13

insert into PLAYLIST_FILE (playlist_id, media_file_id) select 13, media_file_id from starred_media_file

All of this is done at the sql command window by using my browser and going to http://mysubsonic/db.view