IN works fine in sqlite to find any item in the supplied list. Having said that, I've never used it with a BLOB type. Can't tell from your post but is there a reason you're using BLOB rather than INTEGER?
How is your devicelist formatted? Pete lcSQL Software On May 21, 2015 10:10 AM, "Bob Sneidar" <[email protected]> wrote: > Okay, once again itβs Regex to the rescue. > > There is no function in sqLite to do this sort of thing. Instead one can > use a series of LIKE statements like so: > > SELECT * FROM formsgen.service where devicelist LIKE '6480,%' > OR devicelist LIKE '%,6480' > OR devicelist LIKE '%,6480,%' > OR devicelist = β6480' > > this covers first, last, middle and only conditions > Bob S > > > > On May 21, 2015, at 09:14 , Bob Sneidar <[email protected]> > wrote: > > > > Hi all. > > > > I am having a problem with a query. I have the value β647,6480β in a > column called devicelist. I use the query: > > > > SELECT * FROM formsgen.service where 647 in(device list); > > > > It returns one record as it should. However if I use the query: > > > > SELECT * FROM formsgen.service where 6480 in(device list); > > > > I get NO RECORDS. Am I misunderstanding the IN function? BTW the column > is a BLOB type. Not sure if that matters. > > > > Bob S > > > > > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
