[thelist] Setting a MySQL value to NULL using PHP

rudy r937 at interlog.com
Tue Apr 30 16:08:02 CDT 2002

>SET bar = NULL
>but I am not getting the expect results.

hi jay

that looks okay to me, assuming ID is a character field

if it's not, you probably have some implicit conversion going on, and it's
not giving the string you thought it should

if it's numeric, try using a range test instead, because integer
comparisons are usually faster

something like

   where ID between 100000 and 199999

or whatever your IDs look like


More information about the thelist mailing list