PHP Mysql character issue

Hello,
I am trying to have php change all ` characters to a ' in my mysql db.

I assume it is an escaping issue, but i am not familiar with it enough to know for sure.

Here is what i have but it is not working:

<?php
$mysql=new MySQL();

$result=$mysql->query("UPDATE news SET title = replace(title, "’", "'")");

Can anyone set me straight? Thanks so much for your help.

escaping issue

Why don't you try it ... maybe with LIMIT 1 at the end?

Thanks for your reply Dale, i appreciate it.
Sorry, i am still learning how to write very basic code/queries.

So is this what you are recommending?

UPDATE news SET title = replace(title, "’", "'") LIMIT 1

If you want to convert MS Word "smart" quotes, you might want to try something like:

UPDATE news SET title = REPLACE(REPLACE(title, CHAR(145), '\''), CHAR(146), '\'')

(You could do the same thing for directional double quotes with characters 147 and 148.)