[EMAIL PROTECTED] (Jerry Schwartz) wrote in
news:[EMAIL PROTECTED]:
SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY
book_author WHERE book_title LIKE something;
This actually seems to work, but it makes me ill to look at it.
I doubt this works: there is no FROM
Felix Geerinckx wrote:
[EMAIL PROTECTED] (Jerry Schwartz) wrote in
news:[EMAIL PROTECTED]:
SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY
book_author WHERE book_title LIKE something;
This actually seems to work, but it makes me ill to look at it.
I doubt this
Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 23, 2007 4:46 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Alias a function result?
Jerry Schwartz wrote:
I know
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 24, 2007 3:21 AM
To: mysql@lists.mysql.com
Subject: Re: Alias a function result?
[EMAIL PROTECTED] (Jerry Schwartz) wrote in
news:[EMAIL PROTECTED]:
SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY
book_author WHERE
Jerry Schwartz wrote:
I know that you can alias a function result as easily as anything else, but
I've run into a problem with an application I inherited. For reasons too
murky to go into, I would like to refer to the result of a group function as
the name of the argument of the function. Here's