排序

1. 多个字段组合排序查询

SELECT t.update_time ,t.isfollow_tag,t.create_time,t.* FROM sc_visitor_record t ORDER BY t.isfollow_tag  DESC,t.update_time DESC,t.create_time DESC

2. 自定义排序RDER BY FIELD()

SELECT id,os_id,name,parent_id,project_id,level,create_time FROM pc_project_asset WHERE NAME IN ( '春广场', '夏广场', '秋广场', '冬广场' ) AND dr = 0 ORDER BY FIELD( name, '春广场', '夏广场', '秋广场', '冬广场' ) ASC ;