Reply To: FirePlay Flash client for FireFly

#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.