SQL(ite) question

Bob Sneidar bobsneidar at iotecdigital.com
Tue Jan 14 13:00:06 EST 2020


The only problem I see here is that it is possible to get a match with the last part of one column and the first part of the next, especially with numerical data, which would be a false positive. 

Bob S


> On Jan 14, 2020, at 01:15 , Klaus major-k via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi Sean,
> 
>> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode <use-livecode at lists.runrev.com>:
>> 
>> Even easier:
>> 
>> SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE ‘%mysearchtermhere%’)
> 
> aha, thank you very much, I had no idea this is possible! :-)
> 
>> Sean Cole
>> Pi Digital Prod Ltd
>> 
>>>> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
>>> Actually I do this all the time. 
>>> SELECT * from MyTable where
>>> COLUMN1 like "%mysearchtermhere%" OR 
>>> COLUMN2 like "%mysearchtermhere%" OR 
>>> COLUMN3 like "%mysearchtermhere%" 
>>> I loop through a list of columns I want to search to build the query. 
>>> 
>>> Bob S
>>> 
> 



More information about the use-livecode mailing list