Home > DeveloperSection > Interviews > What is GLOB in SQLite?

Posted on    September-21-2015 12:11 AM

 SQLite Database  Sqlite  Sqlite3 
Ratings:
 1 Answer(s)
  475  View(s)
Rate this:

Jayne Spooner
Jayne Spooner

Total Post:3

Points:15
Posted on    September-21-2015 12:11 AM

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

 


Don't want to miss updates? Please click the below button!

Follow MindStick