SQLで文字列を置換するには、REPLACE関数を使います。 構文 SELECT REPLACE(列名,'置換対象','置換後の文字') FROM test; 使用例 mysql> SELECT name,REPLACE(name,'s','*') FROM ado; +--------+-----------------------+ | name | REPLACE(name,'s','*') | +--------+-----------------------+ | sasuke | *a*uke | | ziro | ziro | | taro | taro | | yama | yama | | sasuke | *a*uke | | sasuke | *a*uke | | sasu | *a*u | | sasu | *a*u | | さすけ | さすけ | +-------
![SQL - 文字列を置換する(REPLACE)](https://cdn-ak-scissors.b.st-hatena.com/image/square/c575a33de704a6ab29c6758804cd9bb4e71410d6/height=288;version=1;width=512/https%3A%2F%2Fwww.sasukepg.jp%2Fwp-content%2Fuploads%2F2018%2F04%2Freplace.png)