[sqlite] Question regarding use of REPLACE

[Simon Slavin]

On 7 Jan 2016, at 4:49pm, audio muze <audiomuze at gmail.com> wrote:

> Is it acceptable to make multiple calls to replace involving the same
> field in a single update operation, like so:
> 
> UPDATE audio SET
>    composer = REPLACE( composer, " / ", "\\" ),
>    composer = REPLACE( composer, " , ", "\\" ),
>    composer = REPLACE( composer, ", ", "\\" ),
>    composer = REPLACE( composer, ",", "\\" ),
>    composer = REPLACE( composer, "\\Jr.\\", ", Jr.\\" ),
>    composer = REPLACE( composer, "\\Jr\\", ", Jr.\\" )
> ;

There is nothing that bans it, but there is no way to know in which order the 
operations are done.  One often sees something like this:

UPDATE audio SET
   composer = REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( composer
                , " / ", "\\" ),
                , " , ", "\\" ),
                , ", ", "\\" ),
                , ",", "\\" ),
                , "\\Jr.\\", ", Jr.\\" ),
                , "\\Jr\\", ", Jr.\\" )
;

Simon.