Top menu

Concatenate a value when updating mysql field

In this post we will show how update string field by concatenating to it?

i need a simple query which update mysql field with its value and some modification for example if field have value (3,4,5) i can add (,6) and this just in case it have value and if its NULL then update the field with the “,”

To insert data into a MySQL database field while preserving the existing data in that field, simply concatenate the new data to the end of the existing data.

Below is an example of how to do this using the field “PAGE_PROFILS”.

If you would like the data that you are entering to appear at the beginning of the existing data, simply flip the concatenation, example:

 

No comments yet.

Leave a Reply