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';
--
Adam Haberlach |A cat spends her life conflicted between a
adam@newsnipple.com |deep, passionate, and profound desire for
http://www.newsnipple.com |fish and an equally deep, passionate, and
'88 EX500 |profound desire to avoid getting wet.