mysql查询按照in里面的数据排序

SELECT `sku` ,`current_price`
FROM `test`
WHERE `sku`
IN (
'aaa', 'bbb', 'ccc', 'ddd', 'eee'
)
ORDER BY FIELD( `sku` , 'aaa', 'bbb', 'ccc', 'ddd', 'eee' )

posted @ 2015-09-16 11:46  Forward1990  阅读(851)  评论(0编辑  收藏  举报