Search SQL Using LIKE instead of CONTAINS

[sid]

Why does the Wappler use whereLike but not whereILike?

The knex library is only used in for NodeJS and the other server languages have a different implementation. I checked the docs and they don’t mention on which databases it will work. They added the feature for ILike somewhere last year. So, I checked the source code, and I actually don’t like how they implemented it. Here are my findings: Postgres all should be working fine; they just generate the ILIKE query as expected. SQLite3 will throw an error, no support there. MySQL the whereILike …