Postgres Pro
Downloads
Home   >   mailing lists

Re: How to use like with a list - Mailing list pgsql-general

From Richard Broersma
Subject Re: How to use like with a list
Date
Msg-id CABvLTWEHtbcH+fhf_-Xi8wxgCE+rvS+jZMdUKgeJRfP2Ym7EYw@mail.gmail.com
Whole thread Raw
In response to Re: How to use like with a list  (John R Pierce <pierce@hogranch.com>)
Responses Re: How to use like with a list  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
On Fri, Nov 18, 2011 at 12:13 PM, John R Pierce <pierce@hogranch.com> wrote:

> where field ~ '^(jo|mo|do|fo)'

Don't forget to add the l as the end:

where field ~ '^(jo|mo|do|fo)l'
--
Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How to use like with a list
Next
From: John R Pierce
Date:
Subject: Re: How to use like with a list