mysql slection in 查询并按照in的顺序进行排列

mysql slection in 查询并按照in的顺序进行排列

demo

SELECT
	( @i := @i + 1 ) '执行顺序',
	id '任务编号',
	REPLACE ( JSON_EXTRACT( executor_param, '$.JOB_TRADE_CODE' ), '"', '' ) '任务CODE',
	job_desc '任务描述',
	executor_param '任务参数',
	author '负责人' 
FROM
	xxl_job_qrtz_trigger_info,(
	SELECT
		@i := 0 
	) AS i 
WHERE
	id IN ( '648961620562808832', '654069826351927296' ) 
ORDER BY
	field(
		id,
	'648961620562808832',
	'654069826351927296')