How to properly set SQLite IN Condition in Android?

Question

Android

Hello!
It is necessary to extract from the database all the records that match the condition (COLUMN_ICON == value1 or value2 or value3 ... etc.)
I'm trying to do it like this:

final String SELECTION = MySQLiteHelper.COLUMN_ICON + " IN ";
        final String[] SELECTION_ARGS = {"default_red", "default_blue"};

        Cursor cursor = mDatabase.query(MySQLiteHelper.TABLE_NOTES,
                allColumns,
                SELECTION,
                SELECTION_ARGS,
                null, null,
                MySQLiteHelper.COLUMN_ID);

This produces an error:

Caused by: android.database.sqlite.SQLiteException: near "ORDER": syntax error (code 1): , while compiling: 
SELECT _id, text, title, icon FROM notes WHERE icon IN  ORDER BY _id

Actually the question is, where did my crooked hands do something wrong?
Thank you.

Answer 1

So immediately and put the values ​​in SELECTION

final String SELECTION = MySQLiteHelper.COLUMN_ICON + " IN ( \"default_red\", \"default_blue\") ";