mysql in ÅÅÐò

select * from ±íÃû where ×ֶΠin£¨×1£¬×2£¬×3£¬×4£©
ÇëÎÊÔõÑù²ÅÄÜÈòéѯ³öÀ´µÄÄÚÈÝ°´×1£¬×2£¬×3£¬×4µÄ˳ÐòÒÀ´ÎÏÔʾ³öÀ´ÄØ£¿

±ÈÈçselect * from ±íÃû where ×ֶΣ¨id£© in£¨1£¬3£¬5£¬4£©
ÔõÑù²ÅÄܲéѯ³öÀ´µÄÄÚÈÝ°´1£¬3£¬5£¬4ÒÀ´ÎÏÔʾÄØ£¿

---

SQL code:
ORDER BY CHARINDEX(','+LTRIM(ID)+',',',1£¬3£¬5£¬4,')

---

ÒýÓÃ

SQL codeORDERBYCHARINDEX(','+LTRIM(ID)+',',',1£¬3£¬5£¬4,')

Ôõô²»ÐÐÄØ£¿

---

SQL code:
ORDER BY CHARINDEX(','+LTRIM(ID)+',',',1,3,5,4,')


ÒòΪÄãÀïÃæµÄ·ûºÅÎÊÌâ,ºÇºÇ,¸Õ²Åû¸Ä

---

MySQL ÖÐ

order by  find_in_set(×Ö¶Î,'1,3,5,4')

---

×¢ÒâÄãµÄ¶ººÅ£¬µ½µ×ÊÇʲôÑùµÄ¶ººÅ£¿ÊÇ,»¹ÊÇ£¬¡¡²»Í¬µÄ·½·¨£¡

http://forum.csdn.net/BList/OtherDatabase ÆäËûÊý¾Ý¿â¿ª·¢

---

ÒýÓÃ

SQL codeORDERBYCHARINDEX(','+LTRIM(ID)+',',',1,3,5,4,')

ÒòΪÄãÀïÃæµÄ·ûºÅÎÊÌâ,ºÇºÇ,¸Õ²Åû¸Ä

CHARINDEXÕâ¸öÊÇʲôѽ£¿

---

SQL code:
MY-SQL²»»á
MS-SQLÖÐ
order by ch