How to update table where 'some_field' is NULL
Code: Select all
$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field = 'NULL'";
mysql_query($sqlquery) or die(mysql_error());
<?php
?>Moderator: General Moderators
Code: Select all
$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field = 'NULL'";
mysql_query($sqlquery) or die(mysql_error());
<?php
?>Code: Select all
<?php
$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field IS NULL";
?>