Re: [SQL] Finding strings inside a field...

Dan Delaney wrote:
>
> 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';

Try this:

SELECT FROM testtable WHERE description like '%foobar%';

Note that this isn't case insensitive.

--
Tim J Trowbridge trowbrid(at)writeme(dot)com
Interested in my genealogy? http://www.execpc.com/~trowbrid