1member
6member
bmember
cadmin
dmember
emember
xmember
李member
马owner
王admin

一楼是最初， 下面是理想效果
字段A 字段B
马 owner
c admin
王 admin
1 member
6 member
b membe
d member
e member
x member
李 member
之前在网上有看到这种写法：select * from "Test" order by (role_name='member',role_name='admin',role_name='owner')
还有这种：order by temps collate "zh_CN"
我想能够先通过角色名，owner,admin,member然后再对字段A进行中文排序

有没有大神，帮一下

select * from "Test" order by (role_name='member',role_name='admin',role_name='owner'), temps collate "zh_CN"
已解决。