← Back to team overview

maria-discuss team mailing list archive

Re: help - i'm not finding one sql function

 


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

Attachment: signature.asc
Description: OpenPGP digital signature


Follow ups

References