mysql count the number of time a character appears code example

Example: count characters of string mysql

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