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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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
and return Demo Inc.?

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

Jim Hall


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-2017 The PostgreSQL Global Development Group