Skip to main content

Return to Answer

"MySQL doesn't have == operator" same edit as answer https://stackoverflow.com/a/40544590/1393894, as they are the same answer. This answer was posted first.
Source Link
edit approved Oct 2, 2019 at 16:42
hammythepig
edit approved Oct 2, 2019 at 16:42
hammythepig
  • 957
  • 2
  • 8
  • 31

You can try this also

 SelectSELECT id , IF(type=='p'type='p', IFNULL(amount,0), IFNULL(amount,0) * -1) as amount fromFROM table

You can try this also

 Select id , IF(type=='p', IFNULL(amount,0), IFNULL(amount,0) * -1) as amount from table

You can try this also

 SELECT id , IF(type='p', IFNULL(amount,0), IFNULL(amount,0) * -1) as amount FROM table
Source Link
Basant Rules
Basant Rules
  • 817
  • 12
  • 9

You can try this also

 Select id , IF(type=='p', IFNULL(amount,0), IFNULL(amount,0) * -1) as amount from table