Re: select exact term

On Thu, Mar 28, 2013 at 1:51 PM, Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu> wrote:

> Is there a way to create a select statement that will select a record if
> the exact term is found in a field that contains the text to describe
> something?****
>
> ** **
>
> If I create a select statement using WHERE description LIKE ‘art’ I get
> every record that has words like depart, start and so on.****
>
> If I create a select statement using WHERE description = ‘art’ I get no
> results even though the word art is in some records description field.****
>
> ** **
>
> Thanks****
>
> ** **
>
> Marc****
>

http://www.postgresql.org/docs/9.2/static/functions-matching.html

--
Douglas J Hunley (doug(dot)hunley(at)gmail(dot)com)
Twitter: @hunleyd Web:
douglasjhunley.com
G+: http://goo.gl/sajR3