how to count a character in mysql variable code example

Example: count characters of string mysql

SELECT    
    LENGTH(<column_name>) AS length     
FROM <table>
WHERE...