search string

//in the dbHelper
public Cursor searchStr(String str){
  SQLiteDatabase db = getReadableDatabase();
  Cursor cursor = db.rawQuery(" SELECT _id FROM "+Vals.PAGES_TABLE_NAME+" WHERE content LIKE '%"+str+"%'", null);
  return cursor;
}
 
//in the search activity
private void search(String str){
        ListView listView = (ListView)findViewById(R.id.resultsListView1);
	String[] from;
	int[] to;
	from = new String[]{"_id"};
	to = new int[]{R.id.listCellTextView};
 
	@SuppressWarnings("deprecation")
	SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.list_cell, db.searchStr(str), from, to);
	listView.setAdapter(adapter);
	listView.setOnItemClickListener(this);
	}