nevadasam — 2011-06-24T18:39:30-04:00 — #1
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 — 2011-06-24T19:30:16-04:00 — #2
do the CONCAT every time you SELECT the data
that's the entire list of your options