In SQLite Database GLOB is an Operator like 'like' operator. GLOB operator is also used for matching string values values against patterns. GLOB operator works as a 'like' operator but the difference between both is that GLOB operator is case sensitive.
For example, if you want to fetch records from any column where name begins with the letter V. sqlite> SELECT * FROM EMPLOYEE WHERE NAME GLOB 'V*';
Total Post:3
Points:15In SQLite Database GLOB is an Operator like 'like' operator. GLOB operator is also used for matching string values values against patterns. GLOB operator works as a 'like' operator but the difference between both is that GLOB operator is case sensitive.
For example, if you want to fetch records from any column where name begins with the letter V.
sqlite> SELECT * FROM EMPLOYEE WHERE NAME GLOB 'V*';