Q: what wrong with my sqlite query ? Im using sqlite over android and i keep getting the same exceotion and i can't understand why 
The table is 
"CREATE TABLE IF NOT EXISTS " + STUDENTS_TABLE
                            + "(" + STUDENT_ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "
                            + STUDENT_NAME + " TEXT NOT NULL, "
                            + GROUP + " TEXT NOT NULL, "
                            + CONSTRAINT name_unique UNIQUE (STUDENT_NAME, GROUP));";

and the query that i take is ( try to get all student that are in specific group ) 
        String query = "SELECT * FROM " + STUDENTS_TABLE + " WHERE group + "=" + groupName;

The exception is 
android.database.sqlite.SQLiteException: near "group": syntax error (code 1): , while compiling: SELECT * FROM students WHERE group=class1

#

Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
    (near "group": syntax error (code 1): , while compiling: SELECT * FROM students WHERE group=class1)

#

and i can't see anything wrong in my query

A: You have to put quote so sqlite will detect it as a string. Try this :
String query = "SELECT * FROM `" + STUDENTS_TABLE + "` WHERE `group` + "='" + groupName +"'";

