如何对查询的结果按照自己的规则排序

Question

Select * from f_account
where ACCT_ID in (3,4,2)
ORDER BY charindex(','+convert(varchar,ACCT_ID)+',','3,4,2')

        这是在网上找的，不知道 是不是写的不对，报错
        [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar,ACCT_ID)+',','3,4,2')' at line 3

Answer 1

数据库查询结果都是放在集合里的，返回的是集合，你可以定义一个对应的集合来接收它，然后你想怎么显示不都随你心情了吗