RobbH wrote:
> If I understand what you're saying, and I may not, doing what I want
> with SQL would require at least two steps: first, select for files where
> genre="Country", then select from files selected the first time for
> files where genre="Instrumental". I think I've seem some examples of
> nested SQL queries. Might it be possible to do what I want that way? In
> other words, instead of storing the results of the first query in a
> temporary table to be used by the second query, a single query would
> first select for Country, then a subquery would operate on that
> selection to find Instrumental files.
i am a mysql guy most things do work with sqlite as well but i am rusty
and old now..
eg - That track has 3 Genres.
Code:
--------------------
sqlite> select * from genre_track where genre_track.track like '55557';
28|55557
18|55557
40|55557
--------------------
Check
Code:
--------------------
select * from genre_track where genre_track.track like '55557' and
genre_track.genre like '18';
18|55557
--------------------
one match like it should
Code:
--------------------
select * from genre_track where genre_track.track like '55557' and
genre_track.genre like '18' and genre_track.genre like '28';
sqlite>
--------------------
no match cause its the same table - there are some joins and temp.
tables needed but like i already wrote i am rusty and old ;-)
------------------------------------------------------------------------
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=109818
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
