Thanks Richard.
On Mon, Feb 25, 2013 at 6:54 PM, Richard Hipp <d...@sqlite.org> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users