Select

From: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>
To: Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br>
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Select
Date: 2002-01-24 14:22:57
Message-ID: 15440.6337.563011.540515@elsick.csl.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

See:

http://www.postgresql.org/idocs/index.php?functions-matching.html

In your case SELECT * FROM xxx WHERE name LIKE '%Jose%';

Lee.

Marcelo Pereira writes:
> How can I select from a table all the tupples with a specific word?
>
> Ex.: I have a table like this:
>
> 1 | 'Jose' Carlos Santos
> 2 | Maria 'Jose' Pinheiro
> 3 | Joaquim 'Jose' Castro
> 4 | Marcelo Pereira Sa
> 5 | Chuck Hagen
> 6 | John 'Jose' Pinto
>
> I would like to select all the tupples with the work 'Jose'. So, the
> tupples: 1,2,3 and 6.

In response to

  • Select at 2002-01-24 13:34:36 from Marcelo Pereira

Browse pgsql-general by date

  From Date Subject
Next Message Bo Lorentsen 2002-01-24 14:29:42 Re: Select
Previous Message Marcelo Pereira 2002-01-24 13:55:00 Re: Auto Increase