1, Substring_index (inaccurate):
SELECT * from ' tvmars_channel ' WHERE ' name ' in (' Zhang Yimou ', ' 1080P ', ' Hong Kong movie ', ' Hollywood ', ' comedy movie ', ' action movie ') Order by Substring_index (' Zhang Yimou, 1080P, Hong Kong movie, Hollywood, comedy movie, action movie ', name,1);
2, Find_in_set:
SELECT * from ' tvmars_channel ' WHERE ' name ' in (' Zhang Yimou ', ' 1080P ', ' Hong Kong movie ', ' Hollywood ', ' comedy movie ', ' action movie ') Order by Find_in_set (name, ' Zhang Yimou , 1080P, Hong Kong movie, Hollywood, comedy movie, action movie ')
3. FIELD:
SELECT * from Tvmars_channel WHERE name in (' Zhang Yimou ', ' 1080P ', ' Hong Kong movie ', ' Hollywood ', ' comedy movie ', ' action movie ') ORDER by FIELD (name, ' Zhang Yimou ', ' 1080P ', ' Hong Kong movie ', ' Hollywood ', ' comedy movie ', ' action movie ';
Select in sort MySQL select in (array) Order by array