UPDATE table_name SET column_name = REPLACE(column_name,"search str","replace str");. Putting t.column_name in the first argument of replace did ... ... <看更多>

... <看更多>

If the format is always exactly one space either side of a lowercase and , then you don't need regexp_replace as plain old replace will do ... ... <看更多>