Addig string to text field in sqlite


Hi everyone, i want to add data to a text field in sqlite, something like the following:

UPDATE temp SET field = field + " - new data" WHERE field = "old data"

what im expecting is to store "old data - new data", is there a way to do that?


The string concatenation operator is ||.


thank you very much!!!!