Updating fields in one table that are not empty

Posted by WmasterJ on Stack Overflow See other posts from Stack Overflow or by WmasterJ
Published on 2010-05-21T18:13:14Z Indexed on 2010/05/21 18:20 UTC
Read the original article Hit count: 189

Filed under:
|
|

I got this SQL:

UPDATE users2 
SET picture = 'sites/site2/files/pictures/' + picture;
WHERE picture NOT IS NULL

And the only thing I get are that all picture fields get the value '0'.

© Stack Overflow or respective owner

Related posts about drupal

Related posts about mysql