I have been looking through the documentation of sqflite flutter package, I could not find how to use the AND statement in their documentation. Can anyone help me with this. Below is the example of the sql query I would like to execute: SELECT * FROM `table_name` WHERE `column_1` = "some_string" AND `column_2` = "another_string";


Solution 1: Niteesh

List<Map> list = await database.rawQuery('SELECT * FROM Test WHERE column_1 = "some_string" AND column_2 = "another_string"');

Try this This will generate list of map<column_name,value>