On Wed, 02 Jun 2004 05:36:39 -0400, in mailing.database.mysql dan
<dc****@bestweb.net> wrote:
|
| Im sure this has been asked a million times, but Im I couldn't find it.
| So, why not make it 1 million +1.
|
| I am looking for the best way to format html, to be put into a INSERT
| statement. The main problem being the double quotes. Unfortunately not
| using double quotes is not an option.
|
| should I ,
| a. Use regular expressions to change all " to something odd like ~!~. and
| then when I select it again, use another regex to change ~!~ back to ".
| Very ugly method.
|
| b. Use some sort of base64 encoding. not sure how much that slows stuff
| down.
|
| c. use a regex to change the "'s to a \".. Would prefer not to do this
| either.
|
| or d. Some other method.
You could use single quotes. Use regex to convert all " to ' or better
yet to "
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------