Re: select exact term - Mailing list pgsql-admin

From Douglas J Hunley
Subject Re: select exact term
Date
Msg-id CALxYTP4UD6Mimt4XbJUOHk5BnGsYwo38C+xSNZf8uY_Kyy1eiQ@mail.gmail.com
Whole thread Raw
In response to select exact term  (Marc Fromm <Marc.Fromm@wwu.edu>)
List pgsql-admin



On Thu, Mar 28, 2013 at 1:51 PM, Marc Fromm <Marc.Fromm@wwu.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.hunley@gmail.com)
Twitter: @hunleyd                                               Web: douglasjhunley.com
G+: http://goo.gl/sajR3

pgsql-admin by date:

Previous
From: Marc Fromm
Date:
Subject: select exact term
Next
From: Craig James
Date:
Subject: Re: select exact term