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!

1 comment:


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

    ReplyDelete