Re: [Maria-discuss] help - i'm not finding one sql function

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 SPAEmpresarialEng. Automação e Controle