呵呵,创建一个临时表tmp_tab1{ id int auto_increment pk, str varchar(xx), key str (str) }然后把in 里面的写进去然后你就可以from tab_name, tmp_tab1 where tab_name.U_User=tmp_tab1.str order by tmp_tab1.id;
这样可以解决了. select * from talbe where id in(3,2,4,1) ORDER BY FIND_IN_SET( id, '3,2,4,1')
id int auto_increment pk,
str varchar(xx),
key str (str)
}然后把in 里面的写进去然后你就可以from tab_name, tmp_tab1 where tab_name.U_User=tmp_tab1.str order by tmp_tab1.id;
select * from talbe where id in(3,2,4,1) ORDER BY FIND_IN_SET( id, '3,2,4,1')