Jump to content

[SOLVED] Cannot restrict and find only the NULL fields in a database


affc

Recommended Posts

try...

$sql5="UPDATE Details SET datapoint='4' WHERE set='NULL'";

if you want it input as a string

 

or...

$sql5="UPDATE Details SET datapoint='4' WHERE set=''";

if you want the value to be nothing(I think)

 

Regards, ACE

 

EDIT: actually on second thought that doesn't make sense.

Should be a "Solved" button in the bottom left of the post list. Just CTRL-F and type "solved" and the browser should tell you.

 

Glad it worked :D

 

btw, to check for the opposite use IS NOT NULL

 

EDIT: Got my left and right muddled up :/

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.