From: Richard G. Harman Jr
Date: April 12 1999 3:16am
Subject: Re: BUG: query with 'group by' fails to find matching row[s] (fwd)
List-Archive: http://lists.mysql.com/mysql/1672
Message-Id: <Pine.LNX.4.04.9904112315580.1204-100000@linux.innolog.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Yes, infact kalle volkov <cal6@stripped> told me what 'group by' does.

Thank you for all your help, everybody.

Richard


On Sat, 10 Apr 1999, Shaun Batterton wrote:

> 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;
>