[sqlite] Fwd: Question about string concatenation

[malcom]

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