escape the apostrof with a backslash:
select ID from table where sentence = 'does\'t take'
you should do this for some other characters as well, like the backslash
itself.
if you'd use php you could use the function 'addslashes()';
basically what you should do to make a string binary-safe is replace the
following chars:
' -> \'
" -> \"
\ -> \\
<null> -> \0
where <null> is a binary null.
gl
----- Original Message -----
From: "Sofiane Sakhri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 11:37 AM
Subject: Can you Help me? I have Appostroph problem
> Hi, I'm new in mysql,
> I have a problem in the apostroph,
> I would write a query like :
>
> select ID from table where sentence = 'does't take'
>
> Can you help me?
>
> ___________________________________________________________
> Do You Yahoo!? -- Pour dialoguer en direct avec vos amis,
> Yahoo! Messenger : http://fr.messenger.yahoo.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
>
---------------------------------------------------------------------
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
