先来一段变态代码：

    	select 			cs_id,				bs_id,				cb_id,				cs_show_name,				cb_Name,				mb_Name,				logo,				cs_pic,				country,				type,				displacement,				level,				max_price,				min_price,				create_by,				update_by,				create_time,				update_time,				is_deleted,				dealer_update_time,				CsPriceRange    FROM car_serial WHERE 1=1             	  	     	  	            and cb_id in(20057, 10020)	        	        	            and cb_Name LIKE '%${cb_Name}%' 	                                        and `level` like #{level}                        AND cs_pic != 'http://image.bitautoimg.com/autoalbum/V2.1/images/150-100.gif'               	               order by cb_id                                  	order by FIELD(`cb_id`, '20066', '20218', '20005')       	  

自定义排序可以根据字段里的数据进行排序，实在是太好用了

语法如下：

order by FIELD(`cb_id`, '20066', '20218', '20005')