Re: Number of characters
| From: | Dobromir Velev | Date: | Mon, 01 Oct 2001 08:31:22 +0000 |
| Subject: | Re: Number of characters | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12863@lists.php.net to get a copy of this message | ||
Hi,
Have you tried something like
SELECT SUM(LENGTH(field_name)) from table_name;
HTH
Dobromir Velev
-----Original Message-----
From: Cami <cami@fcpl.com>
To: php-db@lists.php.net <php-db@lists.php.net>
Date: Thursday, September 27, 2001 7:04 PM
Subject: [PHP-DB] Number of characters
>Hi guys,
>Does anybody know what will be the easier way to calculate the total amount
>of characters found in a table across the whole fields?
>(using php and mysql)
>Thanks
>Cami
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
>For additional commands, e-mail: php-db-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>