Two things here.
First off, we had this problem spring up on us, and I think I may know why
it's doing it to you. If your using PHP, the more recent version
automatically escape out variables sent to the mysql driver. Thus randy's
is converted to randy's. HOWEVER, if you still have old code where you ran
things through addslashes, it turns out like to look like randy\\\'s. Which
ends up being stored as randy\'s.
To correct this, first fix your code, then run the following query:
UPDATE table SET fieldname = REPLACE(fieldname,'\\','');
----- Original Message -----
From: "Randy Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 13, 2001 9:54 AM
Subject: apostrophe ....
> When a text with an apostrophe in it has a \' in it. How can I fix this?
>
>
> example
>
> randy's is stored in the DB as randy\'s
>
>
> thanks
>
> Randy
>
>
>
>
> ---------------------------------------------------------------------
> 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
