You can concatenate the value in MySQL too, you don't need to process data in PHP (or in client side code).
I assume you have a column in a row with value 'Agree' and want to update it to 'Not Agree'. The following query will change the value from 'Agree' to 'Not Agree' i.e.
- UPDATE table SET
-
opinion = CONCAT( 'Not ', opinion)
-
WHERE id=1
Now the column will have the value 'Not Agree'.
And if you want to append the new value at the end, change the parameters order in the
CONCAT() function.
- UPDATE table SET
-
opinion = CONCAT( opinion, ' Not')
-
WHERE id=1
Are you looking for this?
Checkout
MySQL manual to know more about UPDATE statement.