CODEWITHSUNDEEP
sqldatabasesqlite
Christian
Christian

Reputation: 942

How to append to existing TEXT row [sqlite3]

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

Upvotes: 2

Views: 5391

Answers (1)

Shawn
Shawn

Reputation: 52409

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

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

Upvotes: 12

Related Questions