Wednesday, 25 April 2012

How to order field by its second character?

Hi All,

SELECT first_name, SUBSTR(first_name, 2) as first_name_sub FROM tbl_passport_application ORDER BY first_name_sub DESC;


Cheers!
Posted by at
Labels: ,

1 comment:

  1. Akhil C11 November 2021 at 18:19


    This is really an awesome article. Thank you for sharing this.It is worth reading for everyone.
    Hire PHP Developers in India

    ReplyDelete

Subscribe to: Post Comments (Atom)