Re: BUG: query with 'group by' fails to find matching row[s] (fwd)

[Shaun Batterton]

Richard, I think the query you are interested in is:
select artist,filename from mp3 where full_path like '%mary%' ORDER BY
artist;


not your original query:
>select artist,filename from mp3 where full_path like '%mary%' group by 
>artist;