Re: how to count string occurrence in column - Mailing list pgsql-general

On 27 Aug 2002 at 10:35, Lee Kindness wrote:
> Actually i'm sure the original poster is after something like:
>
>  SELECT count('qwerty qwert qwertyffff fff qq', 'qwerty');
>   count
>  --------
>        2
>  (1 row)

I think this should do it:

select count (*) from table where columnname ~* 'substring';