Author Archives: user

SQLite – LIKE Clause SQLite LIKE operator is used to match text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the LIKE operator will return true, which is 1. There are two wildcards used in conjunction with the LIKE operator − The percent sign (%) The […]

SQLite – GLOB Clause SQLite GLOB operator is used to match only text values against a pattern using wildcards. If the search expression can be matched to the pattern expression, the GLOB operator will return true, which is 1. Unlike LIKE operator, GLOB is case sensitive and it follows syntax of UNIX for specifying THE […]

SQLite – Expressions An expression is a combination of one or more values, operators, and SQL functions that evaluate to a value. SQL expressions are like formulas and they are written in query language. You can also use to query the database for a specific set of data. Syntax Consider the basic syntax of the […]