How do I replace the ' (quotation) character using a MySQL statement

[xl71ohs4xq]

I'm trying to create and XML feed with the result set of a SQL query. One of the fields contains ' characters which is causing an error in the resulting XML file.How do I replace the ' character. I've read posts that suggest something likeReplace(my_column,'''','')But this throws up a syntax errorAny help appreciated