possibly you could use the ascii value of the # character. if you look for
string functions in the manual on mysql.com there is a function (maybe
ASC(int)) that will use the character that corresponds to the integer you
specify.
>From: Siim Einfeldt aka Itpunk <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>
>Subject: Escaping #
>Date: Thu, 24 May 2001 13:14:36 +0200 (EET)
>
>
>Hi,
>
>I have loads of # characters in my database and now I need to make a
>duplicate of it (so assumably will have to escape the needed chracters
>manually), but how could I escape #? Generally speaking it should be \#,
>right? But if do two INSERTs in a row for example:
>INSERT INTO table (one) VALUES ('\#something');
>INSERT INTO table (one) VALUES ('\#somethingelse');
>
>It gives an error, it still thinks # is ment as a comment. What would be
>the solution?
>
>
>Thanks
>Siim EInfeldt
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
