Customize SQL Sort Order(EVA)

haohappy2

于 2013-05-10 15:37:27 发布

阅读量101

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/haohappy2/article/details/84429281

本文介绍如何使用SQL语句优化产品属性查询过程，包括两种排序方式：使用FIELD函数和CASE语句。通过实践示例，了解如何根据产品属性进行高效排序，提升查询性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT  * 
FROM 
	product_attribs  
WHERE pid=##id## 
ORDER BY FIELD(`attrib_name`, 'name','description','subtitle','size','price','unit');

SELECT *
FROM 
	product_attribs
WHERE pid =##id##
ORDER BY CASE attrib_name
WHEN 'name'
	THEN 1
WHEN 'description'
	THEN 2
WHEN 'subtitle'
	THEN 3
WHEN 'size'
	THEN 4
WHEN 'unit'
	THEN 5
WHEN 'new'
	THEN 6
ELSE 7
END ;

If you want customize you sql sort order, you can use above SQL statement.

And both of above can work, but the second one is much better.