文字列置換　REPLACE

カラム内一部置換したいとき
サンプル
全角数字を半角へ

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'０','0') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'１','1') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'２','2') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'３','3') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'４','4') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'５','5') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'６','6') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'７','7') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'８','8') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'９','9') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'円','') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'￥','') WHERE meta_key = 'cost';
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,',','') WHERE meta_key = 'cost';