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 term Marc Fromm <marc.fr...@wwu.edu> 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 even though the ILIKE statement shown > below returns records that do have the word art. Your php app must not be bothering to check for errors :-( ... that's invalid SQL syntax. The bracket constructs are part of the regexp string and need to be inside the single quotes. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
