On Thu, Mar 28, 2013 at 10:51 AM, Marc Fromm 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?
In addition to what has been suggested before you may find interesting
full text search
Thanks Tom, I just discovered that. I reworked the php so the quotes surround
the regexp.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, March 28, 2013 1:07 PM
To: Marc Fromm
Cc: Craig James; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select exact
Marc Fromm writes:
> I am struggling with the syntax. In php I create my where clause as shown,
> using ~* for case insensitive:
> $search = "art";
> $strSQL2 = "WHERE (title ~* [[:<:]]'$search'[[:>:]] OR description ~*
> [[:<:]]'$search'[[:>:]]) ";
> When executed zero records are returned eve
ja...@emolecules.com]
Sent: Thursday, March 28, 2013 11:05 AM
To: Marc Fromm
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select exact term
On Thu, Mar 28, 2013 at 10:51 AM, Marc Fromm
mailto:marc.fr...@wwu.edu>> wrote:
Is there a way to create a select statement that will select a
On Thu, Mar 28, 2013 at 10:51 AM, Marc Fromm 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’
On Thu, Mar 28, 2013 at 1:51 PM, Marc Fromm 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
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
