mysql find how many of certain characters in a string code example

Example: count characters of string mysql

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