Sqlite reverse glob: The glob string is stored in the table and the constant string is in the query

Suppose I have this table:

name|match
a   |*
b   |?
c   |THIS
d   |THAT

Given a value via a replaceable parameter (?), I would like to select the rows where that value is matched by the glob pattern in match.

Examples:

1. Given ? == THIS expect the query to return rows a and c.
2. Given ? == SELF expect the query to return row a.
3. Given ? == A expect the query to return rows a, and b.

This does not work:

SELECT name from table WHERE match GLOB ?

My feeling is the way to achieve the desired behaviour is query without GLOB and then manually perform the glob in the code calling the query.

>Solution :

You have the operands backwards.

SELECT `name` FROM `table` WHERE ? GLOB `match`