dimanche 6 juillet 2014

How to replace value of column with MySQL Query


Vote count:

0




I try yo make some changes to my MySQL database, and I need to change values of this col name "id_lang" which values now is "6" to change to value "2".


This col is found in many tables, it will be great to have a single query which will to this for all DB at once.


by now i found this query,



SELECT REPLACE(yourcolumn,'ValueInTheColumnTobeReplaced', 'NewValue') as replacedColumnName FROM yourtable


PS: I use PHPMYADMIN


but i cant make it work... PLease help me!!!



asked 1 min ago






Aucun commentaire:

Enregistrer un commentaire