[Help] Query to replace just one character...

[Fridgecritter]

I've been in the mysql docs online and asked a few people, but can't seem to get this right running it on my sample database. But I know one of you is a wiz at this and knows the answer off the top of your head.

I need to run a query on the items database, in the name field, that changes all of the apostrophes (') to acute accents (`). I tried RNAME and NAME LIKE, but I am getting my syntax wrong somewhere.

Maybe: UPDATE items SET name = (REPLACE(caption,''','`''));

But I know something's wrong with my formatting.

Thanks a ton in advance.