Check If Column String In Database Is A Substring Of A Query In Sqlite

the current Sqlite syntax can check if a query is a substring of a column string. and I can do a hack to add a % behind the ? described in https://stackoverflow.com/a/5752671/90882

Solution 1:

The LIKE operator checks whether the value on the left matches the pattern on the right. So just put the value on the left, and the pattern on the right. If the pattern needs a % that is not in the database, you have to append it:

SELECT ... WHERE ? LIKE LastUrl || '%' ...