There is currently no built-in function to do this, so I use:
SELECT LENGTH( 'THIS TEST' ) - LENGTH( REPLACE ('THIS TEST','T','');
Answer output is: 3
How to count the number of occurences in a MySQL string
- How to show records for Last Month, This Month, Last Week, This Week, Last Year, This Year in MySQL
- How to get a user’s IP address using PHP