MySQL 添加到列

Question

如何将数据“添加”到列中的现有数据中？

举个例子:我有值(value)观

Mary has 2 brothers

在“家庭”列中，现在我想添加

and one sister

到“家人”才能拥有

Mary has 2 brothers and one sister

Answer 1

如果我清楚地理解你的问题，我想你在更新语句中需要 concat 函数，如下所示:

update your_table
set family = concat(family,' and one sister')
where id = 'blabla'

这是 select 语句:

select concat(family,' and one sister') as family
from your table