maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

Am 19.03.2014 16:04, schrieb Roberto Spadim:
> 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 <mailto: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

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

Attachment: signature.asc
Description: OpenPGP digital signature