Reply To: Creating Smart Playlists


rpedde wrote:

I like the idea generally, but my problem with it is that I don’t have a way to do that in sqlite. MySQL can do something like “select * from songs order by random limit 50” to select 50 random songs.

Sqlite doesn’t have a native function like that, and I can’t think of a sql-y way to do that.

Any ideas?

I didn’t even know that you could do that with sql (MySQL or otherwise), that’s why i was asking…well that’s nice to know 😀

Ok, I’ve finished hyjacking your post now txranger.