How to count all characters in all rows of a field in MySQL?

Question

I need a character to count the sum of all the characters in a text box in MySQL. I need to know the total number of characters of all messages in this field together and cannot think how I will do it ...

Any help would be great.

Thanks.

Answer 1

The number of bytes.,.

select sum(length(your_column_name)) from your_table_name; 

For the number of characters.,.

 select sum(char_length(your_column_name)) from your_table_name; 

The char_length () function supports multibyte characters; five double-byte characters will return as 5.

Answer 2

Just sum all the lengths for the field.

 SELECT SUM(CHAR_LENGTH(field)) FROM table 

Answer 3

CHAR_LENGH (column) counts with spaces. To count all characters, expect spaces, we must first remove the spaces. Hope this helps.

 SELECT SUM(char_length(REPLACE(column, ' ', ''))) FROM table