Re: ORDER BY WITH NO PRINT

[Tobias Asplund]

On Fri, 26 Mar 2004, Seena Blace wrote:

> Select group,hostname,details from table1 order by group;
>
> I want the output should be like
> Group           hostname       details
> aa                xxxxxxxx       abababa
>                    yyyyyyyy       abababababab
>                    zzzzzzzz       anannanananna
> bb                pppppppp        llololololool

Hi Seena,

Try this:

SELECT IF(@a != group, @a := group, '') AS group, hostname, details FROM
table1 ORDER BY group

Cheers,
Tobias

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]