在android中无法使用LIKE函数

Question

不知道为什么sql语句不运行，请帮忙。谢谢

public Cursor getContactMatches(String query, String[] columns) 
{
    String selection = COL_NAME + " LIKE " + "'%" + "%'"; <---- right here
    Log.d("selection", selection);
    String[] selectionArgs = new String[] {query+"*"};

    return query(selection, selectionArgs, columns);
}

Answer 1

在非android平台上测试一下