SQL(ite) question

Klaus major-k klaus at major-k.de
Tue Jan 14 13:05:29 EST 2020

Hi Bob,

> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
> 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. 

AHA, so SQL treats this:
... WHERE ((col1+col2+aCol1+aCol2) ...)

Like this in LC:
... WHERE ((col1 & col2 & aCol1 &aCol2) ...)

> Bob S
> ...
>>> 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. 



Klaus Major
klaus at major-k.de

More information about the use-livecode mailing list