[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