MySql Find and Replace

Hi all,

i’m trying to find and replace a Shortcode throughout my website.

[sc name=”book-consultation-btn”] to this [sc name=”book-consultation-btn-new”]

UPDATE wpeix_posts SET post_content = replace(post_content, '[sc name="book-consultation-btn"]', '[sc name="book-consultation-btn-new"]');

my feel is the issue is ” (double quote mark) in the shortcode, is there a way around this?

help?