Re: [GENERAL] Select

[newsreader]

On Tue, Apr 17, 2001 at 09:23:02AM -0300, Marcelo Pereira wrote:
> Hi All,
> 
> 
> Now I would like to select all employees which name begins with the letter
> "P".....
> 
> > Select * from employee where "name-begin-with-letter-P"....  :-)
> 

select * from employee where email ~ '^P';

or if case does not matter

select * from employee where upper(email) ~ '^P'; 

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster