尝试从 Android Sql 中提取某些记录

Question

我试图从 MySql Android 数据库中仅提取包含“电影”字段的记录。我的代码看起来像这样：

Class Name:MediaDbAdapter
Database table name: records
column name:KEY_TYPE

mDb.query(records, new String[] {MediaDbAdapter.KEY_TYPE},
            "KEY_TYPE = " + "'movie'",  null, null, null, null);

只是不工作......

Answer 1

mDb.query(records, new String[] {"KEY_TYPE"}, "KEY_TYPE = 'movie'", null, null, null, null);

试试这个

Answer 2

db.query(TABLE_NAME, new String[] {"KEY_TYPE"}, 
            "KEY_TYPE = " + "'movie'", null, null, null, null);