Re: [sqlite] LIKE Query with ESCAPE character

On 2/27/19, julian robichaux wrote: > Am I doing something wrong here, or perhaps misunderstanding the > documentation? My expectation is that both LIKE queries will use the > index, but the EXPLAIN QUERY PLAN results tell me something different. There was an issue with the LIKE optimization

Re: [sqlite] like query

On Wed, Feb 27, 2013 at 3:16 PM, Igor Tandetnik wrote: > On 2/27/2013 4:35 AM, Dominique Devienne wrote: > >> PS: Something else that should also be part of SQLite built-in is the >> optimization that col LIKE 'prefix%' queries should implicitly try to use >> an index on col.

Re: [sqlite] like query

On 2/27/2013 4:35 AM, Dominique Devienne wrote: PS: Something else that should also be part of SQLite built-in is the optimization that col LIKE 'prefix%' queries should implicitly try to use an index on col. http://www.sqlite.org/optoverview.html#like_opt -- Igor Tandetnik

Re: [sqlite] like query

On Wed, Feb 27, 2013 at 11:23 AM, Clemens Ladisch wrote: > Dominique Devienne wrote: > > My $0.02 is that such a chr() function could/should be built-in to > SQLite. > > Apparently, drh has a time machine: > http://www.sqlite.org/cgi/src/info/209b21085b > Indeed! Spooky :)

Re: [sqlite] like query

Dominique Devienne wrote: > My $0.02 is that such a chr() function could/should be built-in to SQLite. Apparently, drh has a time machine: http://www.sqlite.org/cgi/src/info/209b21085b Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] like query

On Tue, Feb 26, 2013 at 2:31 PM, Clemens Ladisch wrote: > ... 'somedata/' || CAST(x'F48FBFBF' AS TEXT) > Great trick! But it hardly qualifies as user friendly though, no? For our app, I added a chr() SQL function that take an arbitrary number of integers and UTF-8 encodes

Re: [sqlite] like query

On Tue, Feb 26, 2013 at 12:34:03PM +, Simon Slavin scratched on the wall: > On 26 Feb 2013, at 7:39am, dd wrote: > > This database has unicode strings(chinese/japanese/...etc strings). can > > you tell me which is the correct character to replace with z? > > Ah.

Re: [sqlite] like query

On 2/26/2013 9:25 AM, dd wrote: Igor/Clemen Ladisch, SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/z" I want to replace z with 10 character. But, it's failed. Failed in what way? How do you run your query? Show your code. -- Igor Tandetnik

Re: [sqlite] like query

On 2/26/2013 9:18 AM, dd wrote: 10 decimal value is 1114111. But, some chinese characters are greater than this value. You are mistaken. There are no Unicode characters above U+10, whether Chinese or otherwise. -- Igor Tandetnik ___

Re: [sqlite] like query

Igor/Clemen Ladisch, >>SELECT * FROM emp WHERE column_test BETWEEN "somedata/" AND "somedata/z" I want to replace z with 10 character. But, it's failed. what is the correct decimal value for that? On Tue, Feb 26, 2013 at 6:18 PM, dd wrote: > 10 decimal value is

Re: [sqlite] like query

10 decimal value is 1114111. But, some chinese characters are greater than this value. Is it correct character(10) to replace with z? Please correct me if I am doing wrong. On Tue, Feb 26, 2013 at 5:58 PM, Igor Tandetnik wrote: > On 2/26/2013 8:31 AM, Clemens

Re: [sqlite] like query

On 2/26/2013 8:31 AM, Clemens Ladisch wrote: Igor Tandetnik wrote:> On 2/26/2013 2:39 AM, dd wrote: 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

Re: [sqlite] like query

Igor Tandetnik wrote:> On 2/26/2013 2:39 AM, dd wrote: >> 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? > > U+, of course.

Re: [sqlite] like query

On 2/26/2013 2:39 AM, dd wrote: >>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? U+, of course. -- Igor Tandetnik

Re: [sqlite] like query

On 26 Feb 2013, at 7:39am, dd wrote: >>> 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? Ah.

Re: [sqlite] like query

>>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 wrote:

Re: [sqlite] like query

Thanks Richard. On Mon, Feb 25, 2013 at 6:54 PM, Richard Hipp wrote: > On Mon, Feb 25, 2013 at 9:46 AM, dd wrote: > > > Hi, > > > > Table has string data type column. format of strings: > > somedata1/somedata2/somedata3 > > > > I have written query

Re: [sqlite] like query

On 25 Feb 2013, at 2:46pm, dd 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

Re: [sqlite] like query

On Mon, Feb 25, 2013 at 9:46 AM, dd 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