Addig string to text field in sqlite


#1

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?


#2

The string concatenation operator is ||.

https://www.sqlite.org/lang_expr.html


#3

thank you very much!!!!