Re: Selecting rows having substring in a column

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Selecting rows having substring in a column
Date: 2019-08-29 15:15:14
Message-ID: 0e231701-466e-2119-d31f-8f66ebe48e89@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 8/29/19 8:47 AM, Rich Shepard wrote:
> On Thu, 29 Aug 2019, Gary Cowell wrote:
>
>> Look at the 'LIKE' function
>
> Gary,
>
> Yes, I thought of like but didn't think to look for it in the postgres
> manual.
>
> Thank you very much,
>
> Rich
>
>
I've given up on the "likes" in favour of the ~ (tilde) and ~* (tilde
asterisk) operator.  Way cool, powerful. Not standard sql though (iirc)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2019-08-29 16:02:51 Re: Selecting rows having substring in a column [RESOLVED]
Previous Message Rich Shepard 2019-08-29 14:47:49 Re: Selecting rows having substring in a column