Subsonic Forum • View topic - Help SQL statement to list all artists?

Help SQL statement to list all artists?

Moderator: moderators

3 posts • Page 1 of 1

Help SQL statement to list all artists?

by bcrivers » Mon Nov 30, 2015 5:43 pm

Does anyone know the correct structure for an SQL statement to list all the artist without duplicates?

bcrivers: Posts: 24; Joined: Sun Aug 28, 2011 10:20 pm

Re: Help SQL statement to list all artists?

by mitrailer » Mon Nov 30, 2015 5:46 pm

Code: Select all: SELECT DISTINCT artist FROM media_file

mitrailer: Posts: 138; Joined: Fri May 09, 2014 12:35 am

Re: Help SQL statement to list all artists?

by bcrivers » Mon Nov 30, 2015 6:16 pm

Thank you!

bcrivers: Posts: 24; Joined: Sun Aug 28, 2011 10:20 pm

3 posts • Page 1 of 1

Return to General

Who is online

Users browsing this forum: No registered users and 5 guests