mysql count occurrences of character in string code example

Example: count characters of string mysql

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