[thelist] Setting a MySQL value to NULL using PHP

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


>UPDATE tblFOO
>SET bar = NULL
>WHERE ID LIKE '10%'
>
>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


rudy




More information about the thelist mailing list