Re: [GENERAL] Wild Cards

2001-01-27 Thread Oliver Elphick
Adam Haberlach wrote: On Thu, Jan 25, 2001 at 08:40:23AM -0500, No Name 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

Re: [GENERAL] Wild Cards

2001-01-26 Thread Adam Haberlach
On Thu, Jan 25, 2001 at 08:40:23AM -0500, No Name 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'; --