Re: SQL IN() function

[Bob Sneidar]

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 <bobsnei...@iotecdigital.com> 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
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode