Re: how to count string occurrence in column
От
Jules Alberts
Тема
Re: how to count string occurrence in column
Дата
Msg-id
200208270952.g7R9q9SM028562@artemis.cuci.nl
Ответ на
Re: how to count string occurrence in column (Lee Kindness)
Список
Дерево обсуждения
how to count string occurrence in column "Ben-Nes Michael" <miki@canaan.co.il>
Re: how to count string occurrence in column "Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: how to count string occurrence in column Lee Kindness <lkindness@csl.co.uk>
Re: how to count string occurrence in column "Jules Alberts" <jules.alberts@arbodienst-limburg.nl>
Re: how to count string occurrence in column "Jules Alberts" <jules.alberts@arbodienst-limburg.nl>
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';
В списке pgsql-general по дате отправления
