doujiongqin0687 2013-01-03 00:10
浏览 24
已采纳

设置非典型排序顺序

I'm working with a database where end users can upload photos of their collectibles and other effects, and under one of the criteria they can add entries is the condition of the product (near mint, mint, excellent, etc). If I want to sort these entries by condition, it will sort it alphabetically, but this doesn't correspond to the actual sorted-by-condition. For example, E (excellent) will appear before M (mint), when excellent is worse than mint.

How can I assign values to these letters in my database so when sorted they will appear in an order that is not alphabetic, but by actual grade (M > NM > E > G > P).

  • 写回答

3条回答 默认 最新

  • doulu5109 2013-01-03 00:14
    关注

    Add a case statement to the order by clause. Here is some pseudo sql:

    SELECT * FROM COLLECTIBLES
    ORDER BY CASE condition
      WHEN 'EXCELLENT' THEN 1
      WHEN 'MINT' THEN 2
      WHEN 'NEAR MINT' THEN 3
      ELSE 4
    END
    

    Working Example: http://sqlfiddle.com/#!2/328c2/1

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!
  • ¥15 vmtools环境不正常
  • ¥15 请问如何在Ubuntu系统中安装使用microsoft R open?
  • ¥15 jupyter notebook
  • ¥30 informer时间序列预测
  • ¥20 SSR引物多态性分析
  • ¥15 大漠插件在Win11易语言注册调用和免注册灵异事件,VS上注册调用完全没问题
  • ¥15 Addressable缓存机制做热更新的问题