mysql - sql中能否按id指定顺序取出数据?
阿神
阿神 2017-04-17 16:18:14
0
3
598
id: 3,2,5,10,4 select * from id in (3,2,5,10,4);

但是顺序会乱。sql中有没有自带的处理函数?

------------------补充------------------------------

想利用mysql中limit做分页,所以想在mysql中原生解决。

阿神
阿神

闭关修行中......

reply all (3)
Ty80

SELECT * FROMuser_info_tblwhere id in (150633922,150986697,7000084,7000083) order by find_in_set(id,'150633922,150986697,7000084,7000083');

    阿神

    select *from table where id in (3,2,5,10,4) order by FIND_IN_SET(id,'3,2,5,10,4');

      迷茫

      Select Id From Uid Where Id!='' Order By FleId(Id,2,3,1);

        Latest Downloads
        More>
        Web Effects
        Website Source Code
        Website Materials
        Front End Template
        About us Disclaimer Sitemap
        php.cn:Public welfare online PHP training,Help PHP learners grow quickly!