Update one column - Conditinally, update 2nd column. Can it be done?

[southbeach]

I am using PHP/MySQL. I have the following query:

$usql = 'UPDATE `productsd` SET 
pdQtyOnh = pdQtyOnh - ' . $qty . ' 
WHERE pdID = ' . $key . ' LIMIT 1;';

There is a second column named pdStatus. I would like to set status to "X" if column pdQtyOnh <= $qty.

How can I do this?

Thanks!

 

[obadare]

http://dev.mysql.com/doc/refman/5.0/en/case-statement.html