SQLite Forum

sqlite3 LIKE clause with parameters for c api
> "SELECT ... FROM ... WHERE col LIKE '%%'+?1+'%%';"

In SQL the string concatenation operator is `||`, so:

`SELECT ... FROM WHERE col LIKE '%' || ?1 || '%'`

Whether or not the % signs need to be doubled depends on the exact API you're passing the string to, but `sqlite3_prepare_v2()` does not expand/process percent signs so do not double them.