On Mon, Feb 25, 2013 at 9:46 AM, dd <durga.d...@gmail.com> wrote: > Hi, > > 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? >
The query might go faster if you do: CREATE INDEX emp_idx1 ON emp(column_test COLLATE nocase); Or, if you really intended to do a case-sensitive search, you could say: SELECT * FROM emp WHERE column_test GLOB 'somedata/*'; > > Thanks in advance. > > Best Regards, > dd. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users