Re: 'select where' using multiple columns.

From: Hélder M(dot) Vieira <hmv(at)mail(dot)telepac(dot)pt>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: 'select where' using multiple columns.
Date: 2005-08-05 10:43:19
Message-ID: 008601c599aa$7f821a10$580bfea9@hmv02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2005-08-05 10:48:06 Re: Make C file for create type
Previous Message daq 2005-08-05 10:37:52 Re: 'select where' using multiple columns.