Postgres Pro
Downloads
Home   >   mailing lists

Select - Mailing list pgsql-general

From Marcelo Pereira
Subject Select
Date
Msg-id Pine.LNX.4.20.0201241131340.21033-100000@ni.hmmg.sp.gov.br
Whole thread Raw
Responses Select  (Lee Kindness <lkindness@csl.co.uk>)
Re: Select  (Bo Lorentsen <bl@netgroup.dk>)
List pgsql-general
Tree view 
Hello all,

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.

Thanks in advance,

[ ]'s

Marcelo Pereira

-- Remember that only God and Esc+:w saves.
        __
       (_.\           Marcelo Pereira       |
        / / ___                             |
       / (_/ _ \__    Matematica/99 - IMECC |
_______\____/_\___)___Unicamp_______________/

pgsql-general by date:

Previous
From: Marcelo Pereira
Date:
Subject: Re: Auto Increase
Next
From: Lee Kindness
Date:
Subject: Select