yes, but i have a table with 1M rows, and i don't have php/c/python/perl here, just heidisql
any help is wellcome


2014-03-19 12:03 GMT-03:00 Reindl Harald <h.reindl@thelounge.net>:


Am 19.03.2014 15:51, schrieb Roberto Spadim:
> 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

that is not the job of the database server because it
can't use indexes for such things - just iterate
the result and do it in the application


_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp




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