maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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@xxxxxxxxxxxxx>:

>
>
> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>


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