So I have a field called "fulltext" that is of medium text type. I'm
trying to apply a global text string replace, and in the past I have
had success with the following syntax:

update [table_name]
set [field_name] = replace(
[field_name],
'[string_to_find]',
'[string_to_replace]'
);

I can apply this with no problem to a varchar field, however the
global replacement that I need to execute is on a mediumtext type --
so far I'm generating 1064 MySQL errors when I run this:

update `mos_content`
SET fulltext =
REPLACE(fulltext,'this text','that text');

Thanks for any suggestions!

Chuck