GROUP BY with a string column
| From: | Mauro Boscarol | Date: | Wed, 28 Nov 2001 22:42:37 +0000 |
| Subject: | GROUP BY with a string column | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14674@lists.php.net to get a copy of this message | ||
Can the SUM keyword in SELECT be generalized to strings?
A tipical use for the SUM keyword is:
SELECT column1, SUM(column2)
FROM table
GROUP BY column1
This works only if column2 contains numbers (and SUM is the mathematical sum).
What about obtain the same behaviour, when column2 contains strings (and SUM is string concatenation)?
Anyone help me please?
Thank you
Mauro Boscarol
http://www.boscarol.com