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

[Fridgecritter]

SOLVED

I was using ' ' instead of quotation marks to designate the character to replace (" "). Here is the query I ran on the database to replace all of the apostrophes with acute accents:

UPDATE items SET name = REPLACE(name,"'","`");