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...
Re: [SQL] Finding strings inside a field... |
Список | 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 по дате отправления: