WHAT IS GLOB IN SQLITE?

Jayne Spooner

Total Post:3

Points:15
Posted by  Jayne Spooner
 788  View(s)
Ratings:
Rate this:
  1. Jayne Spooner

    Post:3

    Points:15
    What is GLOB in SQLite?

    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!