Where's iTunes SQL Support?
I’m working on setting up various Smart Playlists in iTunes and every time I’m working with them I totally run into all these shortcomings with the way they work. Like, what if I want all of the pop songs by Depeche Mode and Erasure that show up between 1980 and 1990? You have your choice of AND or OR, right? So it’s “Genre is Pop” and “Year is in the range 1980 to 1990” and… what? “Artist is Depeche Mode” and “Artist is Erasure” won’t work. I need an OR.
Why can’t I just do this:
SELECT * FROM Library WHERE Year BETWEEN 1980 AND 1990 AND Genre = 'Pop' AND Artist IN ('Erasure', 'Depeche Mode')
No reason, that’s why. Come on, guys, get with the program.