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
