<p>On PostgreSQL, use <code>substring</code> function with regex along with multiple columns on <code>order by</code> to properly mix numeric with alphabetical order: </p>
By clicking “Accept all”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage and assist in our marketing efforts. Check our privacy policies.