This SQLite tutorial explains how to use the SQLite AND condition with syntax and examples.
The SQLite AND Condition (also called the AND Operator) is used to test two or more conditions in a SELECT, INSERT, UPDATE, or DELETE statement.
Parameters or Arguments:
condition1, condition2, … condition_n
All of the conditions that must be met for the records to be selected.
Note: The SQLite AND condition allows you to test 2 or more conditions. The SQLite AND condition requires that all of the conditions (ie: condition1, condition2, condition_n) be must be met for the record to be included in the result set.
The following SQLite statement selects all the employee’s from the Position “developer” and the hire_date “2014-01-01”, in the “Employee” table:
SELECT * FROM employee
WHERE position = 'developer'
AND hire_date = '2014-01-01';