Skip site navigation (1) Skip section navigation (2)

Re: % escape

From: Jesus Aneiros <aneiros(at)jagua(dot)cfg(dot)sld(dot)cu>
To: Jie Liang <jliang(at)ipinc(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: % escape
Date: 2000-08-15 19:37:17
Message-ID: Pine.LNX.4.10.10008151535380.23383-100000@jagua.cfg.sld.cu (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-sql
To escape % use \\% as in '50\\%', to escape ' use '' as in 'o''conell',
retrieves o'conell

Regards.

--
Jesus Aneiros Sosa
mailto:aneiros(at)jagua(dot)cfg(dot)sld(dot)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(at)ipinc(dot)com
> www.ipinc.com
> 
> 
> 


In response to

  • % escape at 2000-08-15 19:02:34 from Jie Liang

Responses

pgsql-bugs by date

Next:From: Igor N. AvtaevDate: 2000-08-16 04:09:40
Subject: Truble with compilation
Previous:From: Jie LiangDate: 2000-08-15 19:02:34
Subject: % escape

pgsql-sql by date

Next:From: Madel, KurtDate: 2000-08-15 19:38:09
Subject: RE: Use a rule or a transaction
Previous:From: Jesus AneirosDate: 2000-08-15 19:24:27
Subject: Re: Functions with Null Arguments?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group