Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/8/06, Olaf Beckman Lapré <[EMAIL PROTECTED]> wrote: How would this compare to the performance of simply (progammatically) doing an UPDATE and changing the values in a callback hook. If this is impossbile than even a SELECT with a callback where one does an UPDATE for each returned row

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

: "Jay Sprenkle" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, August 08, 2006 3:35 PM Subject: Re: [sqlite] Replace of substring in sqlite-table - how can I do this? > On 8/8/06, wqual <[EMAIL PROTECTED]> wrote: > > Hi Donald, > >

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/8/06, wqual <[EMAIL PROTECTED]> wrote: Hi Donald, thanks for this valuable comment. Regarding the regexp-function, I am not really sure whether I understood it entirely or not: is it correct that I can use the regexp *only* in external programs (e.g. a perl programme), but not on the sqlite

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Donald, thanks for this valuable comment. Regarding the regexp-function, I am not really sure whether I understood it entirely or not: is it correct that I can use the regexp *only* in external programs (e.g. a perl programme), but not on the sqlite command line? There is no possibility to

RE: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Wolfgang, Regarding: "...thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed!" Sqlite was designed as a small SQL library -- extremely small, considering its capabilities --

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Peter, thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed! Best regards, Wolfgang Am Montag 07 August 2006 pH:19:16 nachmittags/abends schrieb Peter Cunderlik: > On 8/7/06, wqual

Re: [sqlite] Replace of substring in sqlite-table - how can I do this?

On 8/7/06, wqual <[EMAIL PROTECTED]> wrote: Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one?

[sqlite] Replace of substring in sqlite-table - how can I do this?

Hi list, I have sqlite 3.2.1 installed on my computer. Now, I need to replace some substrings in my sqlite-table (for example, replace 'strasse' with 'str.' , german 'ä' with 'ae' etc.). Can I search for the substrings and replace them by another one? I do not know, what would be the right