maria-discuss team mailing list archive

[Carsten Pedersen <carsten@xxxxxxxxxxx>]

On 19-03-2014 15:51, Roberto Spadim wrote:
> 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

SELECT CHAR_LENGTH(field)-CHAR_LENGTH(REPLACE(field, 'n', ''))

Many moons ago, I blogged about something similar, performance 
considerations and how to make your own function:
http://www.bitbybit.dk/carsten/blog/?p=55

Best,

/ Carsten