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.
do the CONCAT every time you SELECT the data
that's the entire list of your options