Addig string to text field in sqlite

General
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

1 Like
3

thank you very much!!!!