From: Date: October 19 2004 11:38am
Subject: Re: Preserving backslashes in DML
List-Archive: http://lists.mysql.com/mysql/174440
Message-Id: <cl2naf$vec$1@sea.gmane.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Tom Kirkman wrote:
> What are the options available for inserting\updating a MySQL table
> VARCHAR with a string containing backslash characters so that the
> backslash characters are preserved as is?  For example, the UNC string
> '\\MyServer\MyDir <file:///\\MyServer\MyDir> ' would be changed on the
> way in to the VARCHAR to become '\MyServerMyDir'.  What options are
> there for specifying that this changing on the way in should NOT be
> done?
> 
Just mask every backslash with another backslash:

'\\\\MyServer\\MyDir'

http://dev.mysql.com/doc/mysql/en/String_syntax.html

HTH,
Wolfram