Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL substring - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: SQL substring
Date
Msg-id 20031112151358.GA30248@wolff.to
Whole thread Raw
In response to Re: SQL substring  (Franco Bruno Borghesi <franco@akyasociados.com.ar>)
List pgsql-sql
Tree view 
On Wed, Nov 12, 2003 at 11:38:31 -0300, Franco Bruno Borghesi <franco@akyasociados.com.ar> wrote:
> ... WHERE field1 LIKE '%' || field2 || '%'

The first way won't work correctly if field2 has %s in it.

> or
> ... WHERE position(field2 in field1)>0

pgsql-sql by date:

Previous
From: Franco Bruno Borghesi
Date:
Subject: Re: SQL substring
Next
From: "Guy Korland"
Date:
Subject: SQL substring