cpd73 wrote:
> You need to use the "LIKE" syntax as detailed before. This allows
> partial string matches. So "WHERE Genre LIKE 'Live;%'" means match where
> Genre starts with "Live;" - you could omit the semi-colon, but I'm just
> safeguarding here.
To be explicit you would need to handle all cases:
Code:
--------------------
UPDATE Tracks set Ignore=1 WHERE Genre='Live'
UPDATE Tracks set Ignore=1 WHERE Genre LIKE 'Live;%'
UPDATE Tracks set Ignore=1 WHERE Genre LIKE '%;Live'
UPDATE Tracks set Ignore=1 WHERE Genre LIKE '%;Live;%'
--------------------
so: only genre, 1st genre, last genre, any genre of track.
*Material debug:* 1. Launch via http: //SERVER:9000/material/?debug=json
(Use http: //SERVER:9000/material/?debug=json,cometd to also see update
messages, e.g. play queue) 2. Open browser's developer tools 3. Open
console tab in developer tools 4. REQ/RESP messages sent to/from LMS
will be logged here.
------------------------------------------------------------------------
cpd73's Profile: http://forums.slimdevices.com/member.php?userid=66686
View this thread: http://forums.slimdevices.com/showthread.php?t=116068
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
