Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL substring - Mailing list pgsql-sql

From Franco Bruno Borghesi
Subject Re: SQL substring
Date
Msg-id 1068647911.4251.3.camel@taz
Whole thread Raw
In response to SQL substring  ("Guy Korland" <korland@cs.Technion.AC.IL>)
Responses Re: SQL substring  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
Tree view 
... WHERE field1 LIKE '%' || field2 || '%'<br /> or<br /> ... WHERE position(field2 in field1)>0<br /><br /> On
Wed,2003-11-12 at 11:07, Guy Korland wrote: <blockquote type="CITE"><pre><font color="#737373"><i>Hi, 
How can I compare two fields if one is a substring of the other?
Something like: ... WHERE StringA like '%' + StringB + '%';

Thanks,
Guy Korland


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
</i></font></pre></blockquote>

pgsql-sql by date:

Previous
From: "Guy Korland"
Date:
Subject: SQL substring
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL substring