jeudi 12 février 2015

how to replace multiple words in sql databse using update query

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