w3resource

SQLite glob() function

Description

The glob(X,Y) function is equivalent to the expression "Y GLOB X".
The X and Y arguments are reversed in the glob() function relative to the infix GLOB operator.
If the sqlite3_create_function() interface is used to override the glob(X,Y) function with an alternative implementation then the GLOB operator will invoke the alternative implementation.

Syntax:

glob(X,Y)

Example: SQLite glob() function

SELECT glob(67,72);

Sample Output:

glob(67,72)
-----------
0

Previous: coalesce()
Next: ifnull()