update positive to negative value in mysql

Question

i have payment table fields

update reason and amount & total field are change negative

UPDATE payment 
SET reason = 'refund' 
WHERE uid =5 AND date = '2012-05-01' AND accid =2 

update single query is it possible?

Answer 1

Use ABS(amount) if you wish to always get the positive integer.

SELECT ABS(5);

will output 5

SELECT ABS(-5);  

will also output 5

Answer 2

If I understand you correctly, you also want to set amount column to positive value along with the above statement.

You can use something like this

UPDATE payment 
SET reason = 'refund', amount = amount * -1, total = total * -1
WHERE uid =5 AND date = '2012-05-01' AND accid =2