FireFly Media Server › Firefly Media Server Forums › Firefly Media Server › Add-on Software › FirePlay Flash client for FireFly › Reply To: FirePlay Flash client for FireFly
15/11/2007 at 8:13 AM
#13373
fizze
Participant
@sonichouse wrote:
@Bo Mellberg wrote:
But it works in “playlist.html” so let’s look in the source for that?
o umlaut is hex C3B6 in the database so the query is ‘daap.songartist:Bj%C3%B6rk’
the SQL used was
bash-3.2# sqlite3 /opt/var/mt-daapd/songs3.db
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> select distinct(hex(distinct(artist))) from songs where artist like 'Bj%';
426AC3B6726B
sqlite> .quit
Just on a sidenote, the SQL query isnt the same as the playlist.html query.
...where artist like 'Bj%';
really shows all songs by all artists that start with “Bj”. Results may not matter much, but a “like” certainly is less performant than an exact match.