Count a spesific character in mysql

if you want to count a spesific character on a string you could use:

select *, LENGTH(REPLACE(email, '@', '')) AS occurrences from tables