Re: [sqlite] Prefix joins

Eleytherios Stamatogiannakis wrote: > select * from a,b where a.c1 LIKE b.c1||'%'; > > but with the additional guarantee for the optimizer that all pattern > matching will happen on the postfix and not on the prefix, so the > optimizer will be able to use an index to do the

[sqlite] Prefix joins

Hello, Is there a version of "LIKE", in SQLite, which makes it clear that we only care to have a pattern on the postfix of a column? An example follows: select * from a,b where POSTFIX_LIKE(a.c1, b.c1 ,'%'); In above example, POSTFIX_LIKE works in the same way as if we had written: select