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