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 <[email protected]>: > > > 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 : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > -- Roberto Spadim SPAEmpresarial Eng. 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
