Re: [sqlite] Fwd: Question about string concatenation

[Gerry Snyder]

malcom wrote:

Hello,
Anyone can translate this SQL query to sqlite? I know that to
concatenate two string you should to use || but I can't port this
query to sql :(

UPDATE table_name
   SET column = CONCAT(column, " other text to add")
   WHERE confront_column_key = "something_key"

Thanks

UPDATE table_name
   SET column = column || ' other text to add'
   WHERE confront_column_key = 'something_key'