Adding the numbers of characters in a record (mysql)
I need to add the number of characters that there are in each of records.

    SELECT 
     CHAR_LENGTH(fiedl1) +
     CHAR_LENGTH(fiedl2) +
     CHAR_LENGTH(fiedl3) +
     CHAR_LENGTH(fiedl4) +
     CHAR_LENGTH(fiedl5) +
     CHAR_LENGTH(fiedl6)
    FROM mytable;

The above code is not valid because if a field contains NULL values then it returns NULL.
Adding the numbers of characters in a record (mysql)
===

I need to add the number of characters that there are in each of records.

    SELECT 
     CHAR_LENGTH(fiedl1) +
     CHAR_LENGTH(fiedl2) +
     CHAR_LENGTH(fiedl3) +
     CHAR_LENGTH(fiedl4) +
     CHAR_LENGTH(fiedl5) +
     CHAR_LENGTH(fiedl6)
    FROM mytable;

The above code is not valid because if a field contains NULL values then it returns NULL.