jeudi 10 mars 2016

Android Database SELECT FROM WHERE

My data is " 1 1/2 Pounds boneless, skinless chicken breasts"

I have this code to search a keyword inside a certain field.

String sQuery= "SELECT _id," + RECIPE_NAME + " FROM " + TBL_NAME +" WHERE ING_1 %" + "'Chicken'" +"%";Cursor c = db.rawQuery(sQuery,null);

I am just searching for a certain word in my data. I dont know how should it be done.

Aucun commentaire:

Enregistrer un commentaire