Finding strings inside a field...

Поиск
Список
Период
Сортировка
От Dan Delaney
Тема Finding strings inside a field...
Дата
Msg-id Pine.BSF.3.96.980629172405.6263I-100000@dionysia.org
обсуждение исходный текст
Ответы Re: [SQL] Finding strings inside a field...  ("Tim J Trowbridge" <trowbrid@execpc.com>)
Re: [SQL] Finding strings inside a field...  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Список pgsql-sql
Hello all.
   Could any one tell me if the following is possible using
PostgreSQL?

I want to be able do a SELECT and search for a string INSIDE OF a
field. So, say I want to get all record in testtable which contain
the word "foobar" inside the "description" attribute. The following
will only get those records in which the "description" attribute
contains ONLY the word "foobar":

SELECT FROM testtable WHERE description='foobar';

What do I need to do to get all the record that have "foobar"
ANYWHERE within the "description" field?
   Thanks a lot.
 --Dan

-----------------------------------------------------------------------
 Daniel G. Delaney                    The Louisville Times Chorus
 Dionysos@Dionysia.org                   www.LouisvilleTimes.org
 www.Dionysia.org/~dionysos/          Dionysia Design
 ICQ Number: 8171285                     www.Dionysia.com/design/
-----------------------------------------------------------------------
                   I doubt, therefore I might be.


В списке pgsql-sql по дате отправления:

Предыдущее
От: James Olin Oden
Дата:
Сообщение: Re: [SQL] gmake not found
Следующее
От: "Tim J Trowbridge"
Дата:
Сообщение: Re: [SQL] Finding strings inside a field...