From: Jean-Luc Lachance <jllachan@sympatico.ca>
To: Markus Bertheau <twanger@bluetwanger.de>
Cc: Keith Gallant <keith@justhosting.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT from a list
Date: Sun, 25 Jul 2004 10:40:22 -0400
Message-ID: <4103C656.4070109@sympatico.ca> (raw)
In-Reply-To: <1090763779.9204.1.camel@teetnang>
References: <PDENIKIKNMLHOJKGJDLGCEPCCGAA.keith@justhosting.ca>
<1090763779.9204.1.camel@teetnang>
Markus Bertheau wrote:
> В Вск, 25.07.2004, в 15:18, Keith Gallant пишет:
>
>>Hello
>>
>>I am wondering if it is possible to use a SINGLE LIKE statement for a
>>selection from a list.
>>
>>For example: If I want to return all results that a phrase starts with a
>>number, can I make a call similar to the following:
>>
>>SELECT * FROM table WHERE phrase LIKE
>>{'0%','1%','2%','3%','4%','5%','6%','7%','8%','9%'};
>>
>>If not is there an easier way than having to call this:
>>
>>SELECT * FROM table WHERE phrase LIKE '0%' OR phrase LIKE '1%' OR phrase
>>LIKE '2%' OR phrase LIKE '3%' OR phrase LIKE '4%' OR phrase LIKE '5%' OR
>>phrase LIKE '6%' OR phrase LIKE '7%' OR phrase LIKE '8%' OR phrase LIKE
>>'9%';
>
>
> WHERE SUBSTRING(phrase FROM 1 FOR 1) IN ('0', '1', ....)
Better yet:
SELECT * FROM table WHERE phrase ~ '^[0-9]';
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jllachan@sympatico.ca, twanger@bluetwanger.de, keith@justhosting.ca
Subject: Re: SELECT from a list
In-Reply-To: <4103C656.4070109@sympatico.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox