On 9 Feb 2014, at 4:21pm, Yuriy Kaminskiy <yum...@gmail.com> wrote: > Unfortunately, builtin LIKE ignores collation, and if you override LIKE (as in > ICU extension), sqlite won't use index for optimization.
However, this particular use of LIKE ... > SELECT * FROM ATable WHERE AColumn LIKE :SearchString || '%' is really just a call to BETWEEN: SELECT * FROM ATable WHERE AColumn BETWEEN :SearchString AND :SearchString||'zzzzzzzzzzzz' And BETWEEN translates into >= and <=. And those /will/ use the index. So implementing a 'greek soundex' function as a collation would be useful, if this is the only use you need to make of LIKE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users