What is GLOB in SQLite?

Last updated:9/21/2020 10:11:17 PM

1 Answers

Anonymous User
Anonymous User

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*';

 

Answer