平成30/ 2018-12-14 11:08
MYSQL/replace 置換

replace(対象文字列, 置換前の文字, 置換後の文字)

select allfield, REPLACE (allfield,'DJ18','HJ18') from recruit where code = 'DJ18';

UPDATE recruit SET allfield=REPLACE (allfield,'DJ18','HJ18') where code = 'DJ18';

( Thanks. )
MySQLだけで文字列を一括置換する
http://webcache.googleusercontent.com/search?q=cache:IR9pYz3lSngJ:blog.tofu-kun.org/070601193853.php+mysql+%E7%BD%AE%E6%8F%9B&cd=1&hl=ja&ct=clnk&gl=jp