[sqlite] Re: Question about string concatenation

thanks a lot 2006/1/20, malcom <[EMAIL PROTECTED]>: > 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") >

[sqlite] Re: Question about string concatenation

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