# 根据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