[sqlite] Re: Question about string concatenation

[Igor Tandetnik]

malcom wrote:

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"

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

Igor Tandetnik