Hi Roberto,<br />You'll have to replace char =&gt; empty and get the difference in length.<br /><br />SELECT (length("banana") - replace("n", "", "banana"))<br /><br />There's probably no "standard" function to do that.<br /><br /><br />Dnia 19 marca 2014 15:51 Roberto Spadim &lt;roberto@spadim.com.br&gt; napisał(a):<br /><br />
<blockquote style="font-size: 12px; padding-left: 1em; margin-left: 1em; margin-bottom: 0px; border-left: #ccc 2px solid;">
<div id="msg">
<div id="msg-body">
<div dir="ltr">hi guys, i'm not finding a function to return how many character i have, for example:
<div> </div>
<div>"banana"</div>
<div> </div>
<div>i want a function that return 2 "n" characters, example:</div>
<div>substr_count("banana","n") =&gt; 2</div>
<div> </div>
<div>sorry it a begginners question, but i didn't found it in mysql/mariadb manual<br clear="all" />
<div> </div>
--<br />
<div dir="ltr">Roberto Spadim<br />SPAEmpresarial
<div>Eng. Automação e Controle</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br /><br />