Working with punctuation and special characters in MySQL Console

Hi

I would like to make site-wide changes to my meta title and meta descriptions using the MySQL Console plugin. The value that I would like to input contains an apostrophe

I have managed to overcome the syntax error with two methods (see below) but both of these result in the apostrophe being replaced with the html code (&#039) in my meta tags

UPDATE cms_exampleTable SET field='value\'s';
UPDATE cms_exampleTable SET field="value's";

Result: value&#039s

I've got 200+ pages to update, so would rather not do each page manually if it can be avoided.

Thanks
Jeff