PasTim wrote: > When you say it doesn't work, what precisely happens? Do you get an > error, or just nothing back? If LIKE '%PARTY%' works, then assuming > this is standard SQL the OR LIKE ... should also work. Are there error > messages in the LMS log? Other syntaxes might work (eg using the IN > keyword). I haven't be able to try this myself as yet. I tried on an older backup, and it is the same. when i try with albums.title LIKE 'DANCE' it works, but when i try albums.title LIKE 'DANCE' OR 'PARTY' , or try albums.title LIKE 'DANCE' OR albums.title LIKE 'PARTY' (the same with %), LMS crashes and i have to reboot.
But i am happy with creating just playlists, which i can use in dynamic playlist. I can exactly achieve what i was looking for. With LMS 8.1 on Raspberry pi4 i can create giant playlists without any problems. Of course it would be nicer to use sql, because then even new files fitting the search would show in the generated results, maybe someone with the sql knowledge can let us know how to do it the right way, to use OR/AND in sql coding... Thank you regards Pommes The Earth Has Music For Those Who Listen ------------------------------------------------------------------------ Pommes's Profile: http://forums.slimdevices.com/member.php?userid=67682 View this thread: http://forums.slimdevices.com/showthread.php?t=109825 _______________________________________________ Squeezecenter mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/squeezecenter
