我正在尝试通过Order by NEWID()以下方式获得随机订单：
public Cursor getSpecialList(String bloodCategory) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cur = db.rawQuery("SELECT " + colName + " ," +
"" + colFather + " ," +
"" + colFamily + " ,"+
"" + colPhone + " from " + ListInfoTable +
" WHERE " + colBloodCategory + "='" + bloodCategory + "'" +
" order by NEWID() ", new String[]{});
return cur;
}
SQLite日志给我以下错误：
没有这样的功能CHANGE
您可以对随机数据使用以下代码：
public Cursor getSpecialList(String bloodCategory )
{
SQLiteDatabase db=this.getReadableDatabase();
Cursor cur=db.rawQuery("SELECT "+colName+" ,"+
""+colFather+" ,"+
""+colFamily+" ,"+
""+colPhone+" from "+ListInfoTable+
" WHERE "+colBloodCategory+"='"+bloodCategory+"'"+
" ORDER BY RANDOM() ",new String[] {});
return cur;
}
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句