Quote:
Originally Posted by zentz
i tried this
update wp_posts set post_content = replace(post_content,'''', ''')
as funky apostrophe is showing as '' in mysql.
the error i get is:
ERROR: Unclosed quote @ 62
STR: '
SQL: update wp_posts set post_content = replace(post_content,'''', ''')
when i try to replace it with something else then ''' , example 'fuck' it works fine. any ideas?
|
bah...my bad i was trying to edit my post and my boss walked in to talk lol...
dont use an actual apostrophe, use & #39 with space removed between & and 3
the funky apostrophe should carry over ok though if you copy/paste it directly from Word