Как использовать оператор "и" в базе данных android
I am working with sqlite in Android. In the query from below I want to use two columns, 'col_4' and 'col_3'. I tried to use the 'AND' operator but it got an error code[1].
For the following query, can someone tell me how to add 'AND'operator:
public boolean checkIfRecordExist(String TABLE_NAME,String
COL_4,String COL_3,String pss,String chek)
{
try
{
SQLiteDatabase db=this.getReadableDatabase();
Cursor cursor=db.rawQuery("SELECT "+COL_4+" FROM "+TABLE_NAME+"
WHERE "+COL_4+"='"+chek+"'",null);
What I have tried:
I tried most and search google but did'nt get any thing else