From: | "mike" <matrix(at)quadrent(dot)net> |
---|---|
To: | "Marcelo Pereira" <gandalf(at)sum(dot)desktop(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Select |
Date: | 2001-04-17 15:26:37 |
Message-ID: | 002701c0c752$cb8d3a90$cfa35bd1@neutrino |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
SELECT * FROM employee WHERE empname LIKE 'P%'
the above would work only if you want to search for people w/ names starting
w/ P
Mike
----- Original Message -----
From: "Marcelo Pereira" <gandalf(at)sum(dot)desktop(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, April 17, 2001 5:23 AM
Subject: Select
> Hi All,
>
> I'm in trouble to build a select...
> I have a table (for example) like this:
>
>
> Table: Employee
> empCod | empName | empDepth
> ---------+-----------+-----------
> 1 | Anand | any
> 2 | Oliver | any
> 3 | Peter | any
> 4 | Bob | any
> 5 | David | any
> 6 | Paul | any
>
> Now I would like to select all employees which name begins with the letter
> "P".....
>
> > Select * from employee where "name-begin-with-letter-P".... :-)
>
> How can I do it ???
>
> Thanks in advance,
>
> Marcelo Pereira
> Unicamp - Brazil
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | PryT | 2001-04-17 15:27:53 | 7.1 rpm problem |
Previous Message | Peter T Mount | 2001-04-17 15:26:35 | Re: JDBC & large Objects |