i need to update records in database for multiple words in sql query e.g update(replace word) all 1 to a, 2 to b, 3 to c etc in sql query i know how to this for single record
UPDATE table
SET column = REPLACE(column, '1', 'a');
but how achieve same for multiple words at once
Aucun commentaire:
Enregistrer un commentaire