Re: Mysql Topic =?ISO-8859-1?Q?Can=B4t?= update when string has semicolon
Tom (Tom.Conlin)
26-Jul-2008/0:52:42-4:00
#44158
<Back Thread Next>
<Back Index Next>
Carlos Lorenz wrote:
> Hi list
>=20
> The query string below just won=B4t work because of the semicolon insid=
e the
> string. Is there a safe way of escaping this semicolon?
>=20
> Update mytable set myfield=3D"blabla;blabla"
>=20
> Anyone?
>=20
have you tried
myfield=3D"blabla\;blabla"
I backslash chars for other DBMSs and it works
<Back Thread Next>
<Back Index Next>REBOL.com