MySQL ADD to column

Question

How would I go about "adding" data to existing data in a column?

For an example: I have values

Mary has 2 brothers

in column "family", now I want to ADD

and one sister

to "family" in order to have

Mary has 2 brothers and one sister

You mean concat? like this w3schools.com/sql/func_mysql_concat.asp — Hotdin Gurning
– Hotdin Gurning, Commented Mar 18, 2018 at 8:43

Hotdin Gurning · Accepted Answer · 2018-03-18 08:48:13Z

2

If I understand your question clearly, I guess you need concat function in update statement like this :

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

And this is for select statement :

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

answered Mar 18, 2018 at 8:48

Hotdin Gurning

1,8193 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1