Mysql根据In里面的数值排序:
SELECT
cardnumber
FROM
cs_person
WHERE
`name` IN (
'何建',
'袁汉文',
'谭权荣',
'罗金弟',
'张群',
'方宏风' ) GROUP BY `name`ORDER BY FIELD(name,'何建',
'袁汉文',
'谭权荣',
'罗金弟',
'张群',
'方宏风');
Mysql根据In里面的数值排序:
SELECT
cardnumber
FROM
cs_person
WHERE
`name` IN (
'何建',
'袁汉文',
'谭权荣',
'罗金弟',
'张群',
'方宏风' ) GROUP BY `name`ORDER BY FIELD(name,'何建',
'袁汉文',
'谭权荣',
'罗金弟',
'张群',
'方宏风');