Can't just replace with nothing?
PHP Code:
$replace = "Replace me";
$new_line = "";
UPDATE table SET value = replace(value, $replace, $new_line) WHERE id= 1