Total Values with MySQL
| From: | shaun | Date: | Mon, 02 Jun 2003 15:18:03 +0000 |
| Subject: | Total Values with MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28232@lists.php.net to get a copy of this message | ||
Hi,
Is it possible to get MySQL to total the values of a select statement, say
'SELECT ColumnName FROM Table WHERE ColumnName = '1''
Say I have three values in ColumnName all of '1' then can I get MySQL to
return 3?
Thanks for your help