Re: Select
От | mike |
---|---|
Тема | Re: Select |
Дата | |
Msg-id | 002701c0c752$cb8d3a90$cfa35bd1@neutrino обсуждение исходный текст |
Ответ на | Select ("Marcelo Pereira" <gandalf@sum.desktop.com.br>) |
Список | 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@sum.desktop.com.br> To: <pgsql-general@postgresql.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 >
В списке pgsql-general по дате отправления: