用MySQL修饰逗号? [英] Trim commas with MySQL?
问题描述
我有一个像下面这样的关键字列表,并且数据库中的某些关键字列表的前导或尾随,
I have a list of keywords like below and some keyword lists in the database have a leading or trailing ,
keyword,keyword,keyword,keyword,
如何使用mysql修剪前导和/或尾随,
?
How do I trim the leading and/or trailing ,
using mysql?
我尝试使用trim
,但似乎无法使其在UPDATE
上正常工作.
I have tried using trim
but can't seem to get it to work on an UPDATE
, which is what I'm trying to achieve.
推荐答案
TRIM(BOTH ',' FROM ',keyword,keyword,')
以上内容将返回'keyword,keyword'
.
BOTH
.
文档
在UPDATE
查询中使用TRIM
应该没有任何问题,但是如果没有相关查询,我们将无法提供任何特定的帮助.但是TRIM
就像任何其他可用函数一样,它需要一组参数并返回一个值.
There shouldn't be any problem using TRIM
in an UPDATE
query, but without the query in question we cannot offer any specific help. But TRIM
is just like any other function available, it takes a set of parameters and returns a value.
示例插入后查询,以修复尾随','
Sample post-insert query to fix fields with trailing ','
UPDATE `table_name` SET `keywords` = TRIM(TRAILING ',' FROM `keywords`);
这篇关于用MySQL修饰逗号?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!