Replace function in MySQL

最新推荐文章于 2021-06-29 13:40:52 发布

redwood_lin

最新推荐文章于 2021-06-29 13:40:52 发布

阅读量733

点赞数

文章标签： function mysql c

本文链接：https://blog.youkuaiyun.com/redwood_lin/article/details/1542764

版权

本文介绍了一种方法，用于将长度小于6的特定字段内的数据替换为空字符串。通过使用MySQL的UPDATE语句实现这一目标，并验证了替换操作的有效性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I want to Replace a column of data to empty if length(column)<6. D1i@@>9sh
2?85Z$j
First of all, I searched "Replace" statement 2~$D< ;$H
+[q&3X9:%
Replace into test_out_realtime SET `PROGRAM` = replace( PROGRAM, '%', '' ) WHERE length( program ) <6 dv%AX8 G
MySQL 5 returns "Error", seems Replace cannot use WHERE condition at back... Y7tPq:i z
|X3B$H
l;AesFRbw
then I tried to use UPDATE, it WORKS!! - sKU;+b a
!(T.+c
update test_out_realtime xj~_uK /
set PROGRAM = '' Q1=,Gc&
where length(PROGRAM) < 6 dF5x>/:
y ?% ==
{"Pi=7g<7g
then !8A^o-+#
select distinct PROGRAM from test_out_realtime where length(PROGRAM) < 6 e<hS*q]
It gives me empty, that means I have replaced all Program legnth < 6 to "empty"