[PHP-DB] GROUP BY with a string column From: Mauro Boscarol (mauro <email protected>)
Date: 11/28/01

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>