Select in sort mysql select in (array) order by array
1. Substring_index (inaccurate):
SELECT * FROM `tvmars_ Channel` WHERE `name` IN ('Zhang Yimou', '1080p', 'Hong Kong Film', 'Hollywood', 'Comedy Movie', 'Action Movie') order by substring_index ('Zhang Yimou, 1080p, Hong Kong Film, Hollywood, Comedy, Action Movie', name,1)
2 、 find_in_set:
SELECT * FROM `tvmars_ Channel` WHERE `name` IN ('Zhang Yimou', '1080p', 'Hong Kong Film', 'Hollywood', 'Comedy Movie', 'Action Movie') order by find_in_set (name,' Zhang Yimou, 1080p, Hong Kong Film, Hollywood, Comedy Film, Action Movie')
3 、 FIELD:
SELECT * FROM tvmars_channel WHERE name IN ('Zhang Yimou', '1080Prundjue', 'Hong Kong Movie', 'Hollywood', 'Comedy Movie', 'Action Movie') ORDER BY FIELD (name,' Zhang Yimou', '1080PPhonery', 'Hong Kong Movie', 'Hollywood', 'Comedy Movie', 'Action Movie')
