select * from page
ORDER BY(
CASE WHEN type='end' THEN 2
WHEN type='start' THEN 0
ELSE 1
ORDER BY(
CASE WHEN type='end' THEN 2
WHEN type='start' THEN 0
ELSE 1
END)
ASC,
page_id asc
type字段排序 把type为start 放在前边,type为end的放在最后,其他放在中间