[SQL] Help with regexp-query

2011-08-02 Thread Johann Spies
I am struggling a bit to do the following type of update in a table. I want the content of a field updated like this: Original: '0894396e-16bf-4e63-aa52-97fe7031eec9||50a6b47c-f69c-414d-bcb6-14bbe403de5f|||' After update:

Re: [SQL] Help with regexp-query

2011-08-02 Thread Tim Landscheidt
Johann Spies jsp...@sun.ac.za wrote: I am struggling a bit to do the following type of update in a table. I want the content of a field updated like this: Original: '0894396e-16bf-4e63-aa52-97fe7031eec9||50a6b47c-f69c-414d-bcb6-14bbe403de5f|||' After update: