使用说明:默认升序
order by field(数据库字段名,字段值1,字段值2,字段值3,字段值4,字段值5,字段值6)
示例:
order by field(AD_TYPE,'HomePage','HomePageDoctorGroup','Xingdong','HomePage_A','HomePage_B','HomePage_C')
结果如下:
使用说明:默认升序
order by field(数据库字段名,字段值1,字段值2,字段值3,字段值4,字段值5,字段值6)
示例:
order by field(AD_TYPE,'HomePage','HomePageDoctorGroup','Xingdong','HomePage_A','HomePage_B','HomePage_C')
结果如下: