I agree with all Paul Larsen's thoughts about stored programs.
@Roberto, my personal opinion:
If you you are counting the occurrences of ONE char, you can use this expression:
LENGTH(col_name) - LENGTH(REPLACE(col_name, 'a', ''))
C functions, even when used in a stupid way (like in this case), are probably much faster than stored functions. If you always search for the same char, maybe you can use a persistent column.
Regards,
Federico
--------------------------------------------
Mer 19/3/14, Peter Laursen
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
mailto: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
it would be so much easier if * reply only to the list so the next reply get not off-list * don't top post * dont reply in HTML to plaintext posts these are the string functions https://mariadb.com/kb/en/string-functions/ * the database would not be faster as a script * frankly the opposite may be true http://bugs.mysql.com/bug.php?id=59253 * there is no function like substr_count * just install PHP or whatever there is not much to help _______________________________________________ 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 -----Segue allegato----- _______________________________________________ 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