Horton

Re: % escape

Jesus Aneiros <aneiros@jagua.cfg.sld.cu>

View thread
From: Jesus Aneiros <aneiros@jagua.cfg.sld.cu>
To: Jie Liang <jliang@ipinc.com>
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Date: 2000-08-15T19:37:17Z
Lists: pgsql-bugs 
To escape % use \\% as in '50\\%', to escape ' use '' as in 'o''conell',
retrieves o'conell

Regards.

--
Jesus Aneiros Sosa
mailto:aneiros@jagua.cfg.sld.cu
http://jagua.cfg.sld.cu/~aneiros

On Tue, 15 Aug 2000, Jie Liang wrote:

> Hi,there,
> 
> Is anybody know  how I can escape % or ' (my column contains % or '  )
> in my text field.
> 
> select mystring from textbook where mystring like .....
> 
> --
> Jie LIANG
> 
> Internet Products Inc.
> 
> 10350 Science Center Drive
> Suite 100, San Diego, CA 92121
> Office:(858)320-4873
> 
> jliang@ipinc.com
> www.ipinc.com
> 
> 
>