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

Try this:

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