If the first search string can be anywhere before the second search string, and the second search string can be anywhere (or nowhere) after the first string, use LIKE '%selkirkst%' OR LIKE '%skyrider1%'
I posted some code, and also a sample stack, for converting an array to a memory database and back again. You could easily copy the arrayToMemoryDB and create a TextToMemoryDB (and it's counterpart) so it will work with delimited text. The conversion process can take some time (milliseconds) so it's not going to overload the matrix! But for the utility of it, it's great, because queries can be quite complex, and can return other values like if/then evaluations. It can sort and return just the columns you are interested in. And for situations where you need to query the database multiple times, the performance will exceed Livecode string searches, because you only need to iterate through the data once for any given dataset. Bob S > On Jun 15, 2018, at 09:50 , Glen Bojsza via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Bob, this is an interesting approach using SQL. I will try and setup a > simple test with SQLite. > > thanks _______________________________________________ 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
