How to order by date and month in sql

I have data like below

     mdate
---------------
    14 Apr
    13 Apr
    05 Oct
    01 May
    19 Jun

But I am not getting any solutions how can I do that.

And I need to order that data like bellow

     mdate
---------------
    13 Apr
    14 Apr
    01 May
    19 Jun
    05 Oct

Here is my query

SELECT * FROM ord_det WHERE mstatus != 'Completed' AND live_status = 'Live' AND public!= 'Hide' ORDER BY LEFT(mdate , 2) ASC, STR_TO_DATE(mtime, '%l:%i %p' ) ASC

Answer

You can use:

order by str_to_date(concat(mdate, ' 2000'), '%d %b %Y')