How do I convert the Microsoft Word apostrophe to an HTML friendly apostrophe?
 

how do i convert ms word apostrophes to html friendly apostrophes in my WP and other mysql databases?

thank you

Replace them with: & #39 ;

which sql should i run?

update table set foo=replace(foo, 'bad', 'good');

best tip is to not use MS word ;)

thats the plan but i have to replace the existing ones

Yeah, it sucks when text writers use word and then I throw it into dreamweaver and all the ' are fucked up

$20 epass to whoever gives me the correct query to execute.

give it to grouchy...

"table" = name of table
"foo" = field name
bad = that bad apostrophe
good = good apostrophe

something like that

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?

You need to escape it. '\'' or '\"'.

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

or yeah escape it like grouchy just said (duh...forgot about that)