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, " / ", "\\" ), composer = REPLACE( composer, " , ", "\\" ), composer = REPLACE( composer, ", ", "\\" ), composer = REPLACE( composer, ",", "\\" ), composer = REPLACE( composer, "\\Jr.\\", ", Jr.\\" ), composer = REPLACE( composer, "\\Jr\\", ", Jr.\\" ) ;