馒头的技术博客
菜单
首页
记录几个特殊排序的例子
作者:
ManTou
分类:
php
时间: 2026-05-07
评论:
暂无评论
在 MySQL 中按照 status 字段的特定顺序 1, 2, 0 排序(审核通过 → 驳回 → 待审核)。
在 MySQL 中有几种方式实现自定义排序:
order by FIELD(status, 1, 2, 0)
order by CASE status WHEN 1 THEN 1 WHEN 2 THEN 2 WHEN 0 THEN 3 END
标签: none
相关文章推荐
上一篇:
win8 10 11 激活方式
下一篇:没有了
订阅本站
(RSS)
订阅→
搜素
Go
文章分类
lnmp
8
js
5
react
1
git
9
redis
4
mysql
10
php
64
laravel
13
闲谈
2
linux
5
python
4
c
0
51
1
go
5
k8s
1
最新文章
记录几个特殊排序的例子
win8 10 11 激活方式
闲谈
记录一组opcache配置
简易验签方案
linux 安全 查看cpu占用
生成随机昵称
docker 导入导出镜像
docker 创建cron 定时任务
docker构建php74+supervisor+cron
归档
May 2026
April 2026
March 2026
February 2026
January 2026
December 2025
September 2025
August 2025
May 2025
April 2025
February 2025
January 2025
December 2024
October 2024
December 2023
May 2023
March 2023
February 2023
January 2023
November 2022
August 2022
July 2022
June 2022
May 2022
April 2022
March 2022
February 2022
June 2021
August 2019
April 2019
December 2018
November 2018
May 2018
April 2018
February 2018
January 2018
August 2017
July 2017
April 2017
February 2017
November 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
热门标签
git
laravel
composer
php
Top ↑