% escape
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
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:
Show quoted text
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 LIANGInternet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873jliang@ipinc.com
www.ipinc.com
Dear Madam or Sir,
Looks like I've found a bug in PostgreSQL, bug report is in attachment.
--
Sincerely yours,
Yury
