Shulou(Shulou.com)06/01 Report--

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')

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.