Append text to a field

[NevadaSam]

I want to learn how to append more text to a field in a table using mysql and php. I thought concat() might be the answer, but I can’t understand it.

So her is what I want to do. Say in table stuff, in field talk is the data ‘Hi’
I want to append " Mom" so ‘Hi Mom’ will be stored in that field. But I don’t want to use UPDATE to do this.

What are my options.

[r937]

@NevadaSam

But I don’t want to use UPDATE to do this.

What are my options.

do the CONCAT every time you SELECT the data

that’s the entire list of your options