In the "search and replace" tool in the field "what to replace" I enter "NULL", but the system does not find such strings. How to replace such strings with the value I need?
Sasha Chernykh
3.576 9 gold signs 23 silver marks 76 bronze marks
Newbie Newbie
386 1 silver mark 8 bronze marks
|
1 answer
phpMyAdmin looks for the string 'NULL' which is not equal to the value of 'NULL', so you will have to use a SQL query
update table_name set column_name = 'value' where column_name is null; 
Maxim Timakov Maxim Timakov
1.607 4 silver marks 14 bronze marks
- And through the "search and replace" can not in any way? Just in pphpmyadmin, for some reason, the layout went, I can’t use the console - Novice
- @ Newbie, maybe I didn’t look good, but I didn’t find how to do it differently. - Maxim Timakov
- @ Newbie can be, but in the drop-down list, choose not =, but 'IS NULL'. - cheops
|