[sqlite] Question regarding use of REPLACE

I'm trying to get some consistency in the contents of a field in a table. To do so involves multiple updates using REPLACE. 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, " / ",

[sqlite] Question regarding use of REPLACE

On 7 Jan 2016, at 4:49pm, audio muze 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, " , ", "\\" ), >