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 <[email protected]>
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
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
