I've tried to sort the coupons table in phpMyAdmin to make finding a coupon code in ZenCart Coupon Admin easier. This sort kind of works but is not completely successful. There seems to be other forces at work the cause the displayed list to show not in pure Coupon Code order.

I looks like dollar discounts are shown first, then percent discounts.

What can I change to always show the list in Coupon Code order?

-Thanks, Alan