checking empty record in one statment

[scialom]

Hello

I have a table with four fields:
user_id
pro
work
country

now I would like to make an update only on the fields that are empty in the db.

Can I do it in one update statement without the need to select first and see if they are empty?

I know that I can do something like this:
update tbl_users where pro!='' or work!='' or country!='' where user_id=$user_id

but this is not exactly what I need.

Any ideas?

[jorgepinho]

Hi,

try this...

if the field is empty it will save the new value
if not it will rewrite itself

UPDATE

pro = IF(LENGTH(pro) < 1; $pro, pro)

this piece of code doesnt check the NULL, but is easily added