Home >Database >Mysql Tutorial >mysql replace函数用法实例
mysql replace函数用法实例
- WBOYOriginal
- 2016-06-02 09:13:031071browse
语法：replace(object,search,replace)
描述：把object中的search全部替换为replace。
实例如下：
<code>UPDATE school_more_info SET comments = replace( comments, '�', "'" )</code>
将comments字段中的特殊字符�替换为’。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mac下修改mysql的密码_MySQLNext article：mysql-数据库连不上求助，请问该从哪几方面改呢