Convert Varchar to Date Format in mysql

SELECT *  FROM `tMembers` where str_to_date(sBirthDay,"%m/%d/%Y") between str_to_date('12/15/1985',"%m/%d/%Y") and str_to_date('09/22/1987',"%m/%d/%Y")

INNER JOIN in MYSQL

SELECT * FROM shipping_name as sn INNER JOIN region_shipping as rs ON (rs.ship_id=sn.id) where rs.reg1!='' and rs.reg_1!='' or rs.reg2!='' and rs.reg_2!='' or rs.reg3!='' and rs.reg_3!='' or rs.reg4!='' and rs.reg_4!='' or rs.reg5!='' and rs.reg_5!='' or rs.reg6!='' and rs.reg_6!='' and sn.ship_price!=''