![]() ![]() We will use the tracks table in the sample database to illustrate how to use the WHERE clause. Reverses the value of other operators such as NOT EXISTS, NOT IN, NOT BETWEEN, etc. Returns 1 if a value is in a list of values. Returns 1 if a subquery contains any rows. Returns 1 if any one of a set of comparisons is 1. ![]() Returns 1 if both expressions are 1, and 0 if one of the expressions is 0. The following table illustrates the SQLite logical operators: Operator Notice that SQLite does not provide Boolean data type therefore 1 means TRUE, and 0 means FALSE. A logical operator returns 1, 0, or a NULL value. Logical operators allow you to test the truth of some expressions. The following table illustrates the comparison operators that you can use to construct expressions: Operator SQLite comparison operatorsĪ comparison operator tests if two expressions are the same. WHERE column_4 BETWEEN 10 AND 20 Code language: SQL (Structured Query Language) ( sql )īesides the SELECT statement, you can use the WHERE clause in the UPDATE and DELETE statements. The search condition in the WHERE has the following form: left_expression COMPARISON_OPERATOR right_expression Code language: SQL (Structured Query Language) ( sql )įor example, you can form a search condition as follows: WHERE column_1 = 100 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |