Re: [sqlite] like-op
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 would also find records where the 4th word was '1', but that will not be possible in my situation. -R. David Morel wrote: Le mer 15/09/2004 à 00:43, Peter a écrit : Rod Dav4is wrote: '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. Actually, you could search the list archive, somebody already wrote such an extension, with astonishing results in terms of speed. I don't remember, I think it was 6 or 8 months ago. -- Regards, Rod Dav4is / P.O. Box 118 / Hyde Park, NY 12538 / USA Genealogy, et Cetera: http://freepages.rootsweb.com/~dav4is/ 391 ancestral & collateral families, mostly 17th - 19th century New England & European roots, total population: 89,400+ Annex: http://www.gencircles.com/users/dav4is/ email: [EMAIL PROTECTED]
Re: [sqlite] like-op
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. Actually, you could search the list archive, somebody already wrote such an extension, with astonishing results in terms of speed. I don't remember, I think it was 6 or 8 months ago. -- *** [EMAIL PROTECTED] OpenPGP public key: http://www.amakuru.net/dmorel.asc signature.asc Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e=2E?=
Re: [sqlite] like-op
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
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
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) So, I guess the bottom line answer is No. -R. D. Richard Hipp wrote: 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 to provide your own implementation of LIKE and/or GLOB that does whatever you want.
Re: [sqlite] like-op
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 to provide your own implementation of LIKE and/or GLOB that does whatever you want. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565