How to count charactors in mysql.

mysql> select char_length('kumudu');
+--------------------------------+
| char_length('kumudu') |
+--------------------------------+
| 6 |
+--------------------------------+
1 row in set (0.00 sec)

You can use this in the where clause too.
Ex:
select * from vote where char_length(message)>1;