Ò»¸ösqlÅÅÐòÎÊÌâ

SQL code:

select id,title from T_QuestionInfo where id in(912,1,899,836,861,556,808,911,859,883)



ÕâÑù²é³öÀ´ÊÇ1,556,808,836,859,861,883,899,911,912
ÕâÑùÊÇ°´idµÄÉýÐòÅÅÐòµÄ  ÎÒÏëÈÃËû°´²éѯµÄin(912,1,899,836,861,556,808,911,859,883)ÅÅÐò

ÇëÎÊÕâÑùÅÅÐòÄØ£¿£¿£¿

---

ÒýÓÃ

SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,')

good ллÀ²¡£

---

°ÙÄêÊ÷ÈËÕæÀûº¦£¬
ºÃÇ¿µÄÌù×Ó£¬

---

ÒýÓÃ

SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,')

UP

---

ÒýÓÃ

SQL codeselect id,titlefrom T_QuestionInfowhere idin(912,1,899,836,861,556,808,911,859,883)orderbycharindex(','+ltrim(id)+',',',912,1,899,836,861,556,808,911,859,883,')

up