mysql替换某字段某字符后面的内容_MySQL
- WBOYOriginal
- 2016-06-01 13:11:131346browse
select substring_index(colum,',',1) #取得替换后的内容update table set colum=substring_index(colum,',',1);
说明：substring_index（被截取字段，关键字，关键字出现的次数）
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：Ubuntu更改MySQL字符集UTF-8,正确显示中文_MySQLNext article：MySQL 大数据操作注意事项_MySQL