file表中有个字段:filename,里面的值是由32位的GUID+真正的文件名。显示在页面上的是真正的文件名,现在我要对截取掉32位GUID后的文件名进行升,降序排序,请问怎么写sql语句啊?
select * from file f
where 1=1
order by f.filename????
select * from file f
where 1=1
order by f.filename????
where 1=1
order by substr(f.filename,33) desc
select * from file f
order by substr(f.filename,33) desc--升序
select * from file f
order by substr(f.filename,33) asc
where 1=1
order by substr(f.filename,33)