How to append to existing TEXT row [sqlite3]

Question

I would like to take an existing TEXT field/row and append to it with sqlite3. I'm finding it somewhat difficult, I've seen some stuff with "upsert."

SQLite - UPSERT *not* INSERT or REPLACE

The specific database I'm working with has no relational connections to any other tables.

Assuming the ideal (pseudo code) UPDATE Table APPEND row values(" text")

assuming row contains "my " I would like it to result in "my text"

Ideally I would like to do this in a single query, but until then I'm left to selecting and using update set

`UPDATE footable SET bar = bar || 'text' WHERE whatever` doesn't work? — Shawn, Sep 04 '19 at 16:02
Woah I didn't think of that, I'll try it. I'll update it afterwards. — Skarlett, Sep 04 '19 at 16:03
@Shawn Worked, thanks. If you wanna add that as the answer I'll mark it as correct. — Skarlett, Sep 04 '19 at 16:07

score 3 · Accepted Answer · answered Sep 04 '19 at 16:13

3

You can use the current values of columns in an update:

UPDATE yourtable SET somecol = somecol || 'text' WHERE somecondition;

answered Sep 04 '19 at 16:13

Shawn

28,389
3
10
37

How to append to existing TEXT row [sqlite3]

1 Answers1