Update clause doesn't return anything

I’m trying to update 10 rows in DB but when using frappe.db.sql(" UPDATE …")
it returns nothing.
I want to know how many rows updated

update_promo_code_query = “”"
UPDATE tabPromoCodes promo
SET promo.number_of_uses = promo.number_of_uses + 1
WHERE promo.code = %(promo_code_id)s AND promo.number_of_uses < promo.maximum_usage
doc = frappe.db.sql(update_promo_code_query, {‘promo_code_id’: promo_code_id})

how to use it in Frappe?

Just call the function with frappe.db.sql

Thanks Bro, It worked