Hi Roberto,
You'll have to replace char => empty and get the difference in length.

SELECT (length("banana") - replace("n", "", "banana"))

There's probably no "standard" function to do that.


Dnia 19 marca 2014 15:51 Roberto Spadim <roberto@spadim.com.br> napisał(a):

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