Re: [sqlite] Fwd: Question about string concatenation

2006-01-19 Thread 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

[sqlite] Fwd: Question about string concatenation

2006-01-19 Thread 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