google了半天，发现一帮人问，但没人贴解决方法，结果自己想出来一个。
the question is: there is no instr(x,y) function in sqlite, and for like(x,y), there is also no concat() function to let you add ‘%’ around the x string.
of course you can write your own functions, but there is actually a tricky way to implement instr(x,y).
instr(x,y) is the same to like(replace(quote(x),””,’%'),y)
tag: sqlite, instr
hope this helps 哈哈
______________
硕士论文狂修改中
