Re: [GENERAL] Wild Cards

2001-01-27 Thread Oliver Elphick
Adam Haberlach wrote: >On Thu, Jan 25, 2001 at 08:40:23AM -0500, wrote: >> I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but >> its not working. can someone show me a example or something? > >It's % and you have to use the LIKE operator. > >SELECT * FROM thi

Re: [GENERAL] Wild Cards

2001-01-26 Thread Adam Haberlach
On Thu, Jan 25, 2001 at 08:40:23AM -0500, wrote: > I am not able to get Wildcards in PostgreSQL, I know its * (asterisk), but > its not working. can someone show me a example or something? It's % and you have to use the LIKE operator. SELECT * FROM thistable WHERE name LIKE '%marley'; -- Adam