Re: [sqlite] like-op

2004-09-15 Thread Rod Dav4is
Low, indeed! It amazes me how ordinary citizens are always ready to jump in with inane remarks like that. As it turns out, LIKE is a lot smarter than I thought, e.g. this works: WHERE FLAGS LIKE '% % 1 %' As long as there are at least 3 blanks in each FLAGS value. I suspect that it

Re: [sqlite] like-op

2004-09-15 Thread David Morel
Le mer 15/09/2004 à 00:43, Peter a écrit : > Rod Dav4is wrote: > > > I'm reminded of the guy who wanted to buy a loaf of bread and was told > > how to build a bakery. ;O) > > Don't hesitate to contact customer services to arrange for your 30day no > quibble refund. :-Þ THAT whas low.

Re: [sqlite] like-op

2004-09-14 Thread Peter
Rod Dav4is wrote: I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) Don't hesitate to contact customer services to arrange for your 30day no quibble refund. :-Þ P.

Re: [sqlite] like-op

2004-09-14 Thread Will Leshner
Rod Dav4is wrote: I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O) My guess is that most of us on this list are building bakeries and not just buying bread.

Re: [sqlite] like-op

2004-09-14 Thread Rod Dav4is
1. Hardly a solution for those who, like me, don't have C, are not into compiling Windows programs, etc. 2. This would make for a bastard version of LIKE or GLOB, which really grates on my nerves. I'm reminded of the guy who wanted to buy a loaf of bread and was told how to build a bakery. ;O)

Re: [sqlite] like-op

2004-09-14 Thread D. Richard Hipp
Rod Dav4is wrote: Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB? You can use the sqlite3_create_function() API

[sqlite] like-op

2004-09-14 Thread Rod Dav4is
Have you given any thought to adding a GREP option to the like-ops? I have a situation where I'd like to select records based on the value of the 3rd word in a particular column. Unless there's a way to do it with LIKE or GLOB? -- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 /