Is there a way in which a string "hello" can be changed into a 'hello' in java (android)?? This is to make my SQL query work. For example
public Cursor GetLecture(String course_code)
{
SQLiteDatabase sqldb = this.getReadableDatabase();
String query = "SELECT * FROM Lecture WHERE course_code =" + course_code;
Cursor C = sqldb.rawQuery(query, null);
return C;
}
Strings are sequence of characters delimited by double quotes. You can't delimit them by single quotes. Those are for characters. This one is in Java.
In case of SQL query, to enclose your string in single quotes, you can do it like this: