>>SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/zzz"
This database has unicode strings(chinese/japanese/...etc strings). can you tell me which is the correct character to replace with z? On Mon, Feb 25, 2013 at 8:13 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 25 Feb 2013, at 2:46pm, dd <durga.d...@gmail.com> wrote: > > > Table has string data type column. format of strings: > > somedata1/somedata2/somedata3 > > > > I have written query to search : select * from emp where column_test > like > > "somedata/%"; > > > > It gives perfomance as per articles in internet. Is it? If yes, what is > > alternate query for this? > > If the format of your 'LIKE' clause is always that you have fixed text at > the beginning, then you can speed up your search a lot. Create an index on > the 'column_test' field, and use this query: > > SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/zzz" > > replace 'zzz' with '~~~' or something similar if you're being really fussy. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users