On 27 May 2014, at 1:58pm, Mike Appenzellar <mappenzel...@gmail.com> wrote:

> WHERE some_int_field LIKE 
> other_int_field which is obviously slower. Any thoughts? Both fields are 
> set as integer. Would be be causing this?

Why on earth are you using LIKE to match integers ? It's for strings.  It'll 
work but it's horrible, as you've already found.

What does your lIKE pattern look like ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to