Yes...
You can just use \' to denote single quotes..
See: http://www.mysql.com/doc/S/t/String_syntax.html
Gurhan
----- Original Message -----
From: "Theodore Morse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 20, 2002 11:48 AM
Subject: escape characters
> Hello everyone!
>
> I have an SQL insert statement that contains "'" symbols in it, however
> as I use the "'" symbol to denote the differences between columns in the
> VALUES(...) part, I was wondering if there was another way of doing it
> so I could include more characters like "'" in the statment, a sample
> would look something like this:
>
> INSERT INTO parts VALUES('val1', 'val2', 'val3')
>
> if I did something like:
>
> INSERT INTO parts VALUES('val1', 'bob's value', 'val3')
>
> it would die, is there anyway to make that valid, like doing a
> \' instead of just '?
>
> Theodore Morse
>
> --
> Theodore Morse
> CIHOLAS Enterprises
> [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
