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.
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 |