TheDeveloperBlog.com

Home | Contact Us

C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML

SQLite Glob Clause

SQLite Glob Clause with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite

<< Back to SQLITE

SQLite GLOB Clause (Operator)

The SQLite GLOB operator matches only text values against a pattern by using wildcards. When the search expression is matched with the pattern expression, the GLOB operator will return true which is 1.

The GLOB operator follows syntax of UNIX for specifying THE following wildcards.

  • The asterisk sign (*): This sign represents zero or multiple numbers or characters
  • The question mark (?): This sign represents a single number or character.

Syntax:

Syntax for asterisk sign: 

SELECT FROM table_name
WHERE column GLOB 'XXXX*'
or 
SELECT FROM table_name
WHERE column GLOB '*XXXX*'

Syntax for question mark:

SELECT FROM table_name
WHERE column GLOB 'XXXX?'
or
SELECT FROM table_name
WHERE column GLOB '?XXXX'
or
SELECT FROM table_name
WHERE column GLOB '?XXXX?'
or
SELECT FROM table_name
WHERE column GLOB '????'

Example:

We have a table named "STUDENT" having following data:

Sqlite Glob clause 1

In these examples the WHERE statement having different BLOB clause with '*' and '?' operators:

Statement Description
WHERE FEES GLOB '200*' Finds any values that start with 200
WHERE FEES GLOB '*200*' Finds any values that have 200 in any position
WHERE FEES GLOB '?00*' Finds any values that have 00 in the second and third positions
WHERE FEES GLOB '2??' Finds any values that start with 2 and are at least 3 characters in length
WHERE FEES GLOB'*2' Finds any values that end with 2
WHERE FEES GLOB '?2*3' Finds any values that have a 2 in the second position and end with a 3
WHERE FEES GLOB '2???3' Finds any values in a five-digit number that start with 2 and end with 3

Example1:

Select all records from "STUDENT" table where AGE start with 2:

SELECT * FROM STUDENT WHERE AGE  GLOB '2*';

Output:

Sqlite Glob clause 2

Example2:

Select all records from table "STUDENT" where FEES start with 2:

SELECT * FROM STUDENT WHERE FEES  GLOB '2*';

Output:

Sqlite Glob clause 3
Next TopicSQLite Limit Clause




Related Links:

.Net

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Java

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

Related Links

Adjectives Ado Ai Android Angular Antonyms Apache Articles Asp Autocad Automata Aws Azure Basic Binary Bitcoin Blockchain C Cassandra Change Coa Computer Control Cpp Create Creating C-Sharp Cyber Daa Data Dbms Deletion Devops Difference Discrete Es6 Ethical Examples Features Firebase Flutter Fs Git Go Hbase History Hive Hiveql How Html Idioms Insertion Installing Ios Java Joomla Js Kafka Kali Laravel Logical Machine Matlab Matrix Mongodb Mysql One Opencv Oracle Ordering Os Pandas Php Pig Pl Postgresql Powershell Prepositions Program Python React Ruby Scala Selecting Selenium Sentence Seo Sharepoint Software Spellings Spotting Spring Sql Sqlite Sqoop Svn Swift Synonyms Talend Testng Types Uml Unity Vbnet Verbal Webdriver What Wpf