MySQL文字列の一部の文字replace関数の削除/置換
275 ワード
replace( ," "," ")
diagテーブルのDiagCodeフィールドの'.'を除去
UPDATE `diag`
SET DiagCode = REPLACE(DiagCode,'\.','')
WHERE DiagCode LIKE '%.%';
replace( ," "," ")
UPDATE `diag`
SET DiagCode = REPLACE(DiagCode,'\.','')
WHERE DiagCode LIKE '%.%';