Re: how to count string occurrence in column

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';