[sqlite] Question about Regular Expression

very much. Malcom

[sqlite] Checking for string length

Hello, is possible with sqlite to return a row with a column string length > n chars? ex: SELECT * FROM TABLE WHERE MY_COLUMN LENGTH > 0 thanks

[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(

[sqlite] Fwd: Question about string concatenation

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