Wildcard queries? - Mailing list pgsql-novice

From James Hall
Subject Wildcard queries?
Date
Msg-id DD6FD0C9668DD311AA040008C7566E8A07EDD1F8@ntmailc.tandy.com
Whole thread Raw
Responses Re: Wildcard queries?  (harrold@sage.che.pitt.edu)
List pgsql-novice
Hello,

I am trying to do a wildcard search on a table, for example:

I have a table - info - that has a text field - business_name.
One value in that field is Demo Inc.

My question is can I execute a query that would search that field for demo*?
Something to the effect of "SELECT * FROM info WHERE business_name LIKE
'demo*';
and return Demo Inc.?


Thanks in advance for any assistance, and for going easy on a newbie. ; )

Jim Hall

pgsql-novice by date:

Previous
From: "Tamara D. Blum"
Date:
Subject: Error installing postgresql 7.1.2
Next
From: Jason Earl
Date:
Subject: Re: How to Make aggragate Function? Standard Deviation?