Skip site navigation (1) Skip section navigation (2)

Wildcard queries?

From: James Hall <James(dot)Hall(at)RadioShack(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Wildcard queries?
Date: 2001-08-15 17:29:59
Message-ID: DD6FD0C9668DD311AA040008C7566E8A07EDD1F8@ntmailc.tandy.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Jason EarlDate: 2001-08-15 17:59:25
Subject: Re: How to Make aggragate Function? Standard Deviation?
Previous:From: Tamara D. BlumDate: 2001-08-15 16:40:57
Subject: Error installing postgresql 7.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group