| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor N. Avtaev | 2000-08-16 04:09:40 | Truble with compilation |
| Previous Message | Jie Liang | 2000-08-15 19:02:34 | % escape |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Madel, Kurt | 2000-08-15 19:38:09 | RE: Use a rule or a transaction |
| Previous Message | Jesus Aneiros | 2000-08-15 19:24:27 | Re: Functions with Null Arguments? |