hi guys, i'm not finding a function to return how many character i have, for example:

"banana"

i want a function that return 2 "n" characters, example:
substr_count("banana","n") => 2

sorry it a begginners question, but i didn't found it in mysql/mariadb manual

--
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle