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