按条件统计COUNT

COUNT(IF(条件, 统计字段, NULL))

SELECT COUNT(IF(t.name = 'UNLOCK',1,null)) FROM t

https://blog.csdn.net/qq_29281307/article/details/103879717
https://blog.csdn.net/qq_39629277/article/details/90754444
https://blog.csdn.net/lr_24353/article/details/129438700

指定id优先查询

SELECT * FROM order WHERE status =1 ORDER BY FIELD(id,11339,7005,3346)

https://blog.51cto.com/u_5712788/6277311

参考文章：

https://blog.csdn.net/qq_29281307/article/details/103879717
https://blog.csdn.net/qq_39629277/article/details/90754444
https://blog.51cto.com/u_5712788/6277311

本文链接： https://jianz.xyz/index.php/archives/248/