SQL

count characters of string mysql

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

mysql count characters in string

#character_count is how many occurences of p there are in "my_column" 
SELECT 
(LENGTH(my_column)-LENGTH(REPLACE (my_column, "p", ""))) AS character_count     
FROM my_table;