Re: select exact term

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux