mysql使用in查询，按照期望的顺序输出结果

最新推荐文章于 2024-01-17 17:52:12 发布

快乐柠檬

最新推荐文章于 2024-01-17 17:52:12 发布

阅读量4.1k

点赞数 1

分类专栏：数据库文章标签： mysql field in

本文链接：https://blog.csdn.net/limenghua9112/article/details/50440694

版权

数据库专栏收录该内容

26 篇文章 0 订阅

订阅专栏

mysql使用in查询，按照期望的顺序输出结果，可以使用field函数

SELECT
	ProvinceId,
	ProvinceName
FROM
	btoc_province
WHERE
	ProvinceName IN ('河南', '辽宁', '山西')
ORDER BY
	FIELD(
		provincename,
		'河南',
		'辽宁',
		'山西'
	);

结果：

MySQL FIELD() function

MySQL FIELD() returns the index position of the searching string from a list of strings. If search string is not found, it returns a 0(zero). If search string is NULL, the return value is 0 because NULL fails equality comparison with any value.

FIELD() is the complement of ELT(). When all arguments of the FIELD() are strings, they are compared as strings. If all arguments are number, they compared as numbers. Other wise all are compared as double.