Re: Selecting rows having substring in a column - Mailing list pgsql-general

From Rob Sargent
Subject Re: Selecting rows having substring in a column
Date
Msg-id 0e231701-466e-2119-d31f-8f66ebe48e89@gmail.com
Whole thread Raw
In response to Re: Selecting rows having substring in a column  (Rich Shepard <rshepard@appl-ecosys.com>)
List 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)



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Selecting rows having substring in a column
Next
From: Rich Shepard
Date:
Subject: Re: Selecting rows having substring in a column [RESOLVED]