django中使用orm根据某字段部分值进行排序

# 根据goods_name前两个字符排序
query_goods_list = PurchaseGoods.objects.filter(goods_cate_id=cate_id, deleted=0).extra(
    select={'goods_name_seq': "left(goods_name,2)"}).order_by("goods_name_seq")
print(query_goods_list.query)

打印的sql语句

SELECT (left(goods_name,2)) AS `goods_name_seq`, .....其他字段` 
 FROM `purchase_goods` 
 WHERE (`purchase_goods`.`deleted` = False AND `purchase_goods`.`goods_cate_id` = 33) 
 ORDER BY `goods_name_seq` ASC