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

Andrei

70