SQLite WHERE Clause
The SQLite WHERE clause is generally used with SELECT, UPDATE and DELETE statement to specify a condition while you fetch the data from one table or multiple tables.
If the condition is satisfied or true, it returns specific value from the table. You would use WHERE clause to filter the records and fetching only necessary records.
WHERE clause is also used to filter the records and fetch only specific data.
In this example, we are using WHERE clause with several comparison and logical operators. like >, <, =, LIKE, NOT, etc.
We have a table student having the following data:
Select students WHERE age is greater than or equal to 25 and fees is greater than or equal to 10000.00
Select students form STUDENT table where name starts with 'A' doesn't matter what come after 'A'.
Select all students from STUDENT table where age is either 25 or 27.
Select all students from STUDENT table where age is neither 25 nor 27.