[Solved] Mysql: How do I subtract a percentage from a number


Try this: 

SELECT amount - (amount * discount_percentage / 100)
FROM tableA;

0

solved Mysql: How do I subtract a percentage from a number