From: Hélder M. Vieira <hmv@mail.telepac.pt>
To: pgsql-sql@postgresql.org
Subject: Re: 'select where' using multiple columns.
Date: Fri, 5 Aug 2005 11:43:19 +0100
Message-ID: <008601c599aa$7f821a10$580bfea9@hmv02> (raw)
References: <42F33585.1090706@rkcomputing.co.uk>
> Is there a way to do something like a
> 'select * where forename_1,forename_2,surname like '%String%' ??
You could try the following, but it won't get a medal for performance...
SELECT * FROM xpto WHERE forename_1 LIKE '%String%' OR forename_2 LIKE
'%String%' OR surname LIKE '%String%'
Helder M. Vieira
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: hmv@mail.telepac.pt
Subject: Re: 'select where' using multiple columns.
In-Reply-To: <008601c599aa$7f821a10$580bfea9@hmv02>
* 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