You are here: Home » Reply

Reply To: Smart Playlist

#9547

fizze
Participant

Playlist by filesystem directory name:
path includes “*directory*”

I also tried
path includes “directory”

Now, in most DBs a wildcard doesnt work like it does in a “normal” regexp.

SQL handles searches or comparisions differently, so an exact match has to be searched with the equals operator = while a “unsharp” search has to be done with the “like” operator.

select id from songs where fpath = 'directory';

vs.

select id from songs where fpath like '%directory%';

The % signs are a wildcard with respect to the “like” operator. They are prepended and appended to the search from the smart playlist when you specify “includes” automatically. 😉