mysql²éѯ½á¹ûÅÅÐòÎÊÌâ

ÎÒÏÖÔÚÓÐÒ»¸ö±í,itemµÄ±í

±í×Ö¶Î:id  text 

ÓÐÒ»¸öarray('5','3','1','2','4')

idÖÐÓÐÖµ1 2 3 4 5 6 7 8 9 10,Õý³£ÅÅÐò

ÎÒÏÖÔÚÏëÒªselect id from item where id in ('5','4','1','2','3')

ÓÐûÓз½·¨Ê¹µÃselect³öÀ´µÄid ²»ÊÇ°´ 1 2 3 4 5ÅÅÐò¶øÊÇ°´5 4 1 2 3 Ò²¾ÍÊÇarrayµÄ˳Ðò


·þÎñÆ÷¶ËÓïÑÔphp.

---

select   id   from   item   where   id   in   ( '5 ', '4 ', '1 ', '2 ', '3 ')   order   by
instr( '5 ', '4 ', '1 ', '2 ', '3 ',id)

---

SQL code:
select id from item where id in ('5','4','1','2','3') order by locate(concat(',',id,','),',5,4,1,2,3,');

---

SQL code:
select id from item where id in ('5','4','1','2','3') order by find_in_set(id,'5,4,1,2,3')

---

ûÓÐÓÃô...

=.=~

---

¸öÈËÒâ¼û£º½¨Ò»¸öÁÙʱ±í´æarry()£»
È»ºó¸ù¾ÝÁÙʱ±íÁªºÏ²éѯ£¬ÔÚ¸ù¾ÝËûÅÅÐò¡£
±¾È˲ËÄñ Ö»ÄÜÕâÑùÏë.µÈ´ý¸ßÊÖ£¡

---

ÒýÓÃ

SQL codeselect idfrom itemwhere idin ('5','