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

Question

Try this:

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

Accepted Answer

Try this:

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