java - 如何选择最后 5 个字符？

Question

我尝试从每行选择最后 5 个符号，并使用以下代码...

public void autoComplete() {

    database = new Database(this) ;
    databaseSQL = database.getReadableDatabase();
    Cursor numbersCursor = databaseSQL.rawQuery("SELECT RIGHT(number, 5) FROM Cars", null);
    number = new String[numbersCursor.getCount()];
    int j = 0;
    while (numbersCursor.moveToNext()) {
        String str_number = numbersCursor.getString(numbersCursor.getColumnIndex("number"));
        number[j] = str_number;
        j++;
    } numbersCursor.close();

...但是查询中的“RIGHT”带有下划线

Answer 1

在SQLite中没有RIGHT()函数。
您必须使用SUBSTR() :

SELECT SUBSTR(number, LENGTH(number) - 4) FROM Cars