how to know the number of specific characters in string mysql code example

Example: count characters of string mysql

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