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';
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. 😉