Page 1 of 1

NULL

Posted: Sun Sep 12, 2004 2:41 pm
by ddragas
Hi all

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

?>

Posted: Sun Sep 12, 2004 2:50 pm
by John Cartwright

Code: Select all

<?php
$sqlquery = "UPDATE mailovi SET some_field = 0 WHERE some_field IS NULL";
?>