Hi Bob, > Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode > <use-livecode@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@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. Best Klaus -- Klaus Major https://www.major-k.de kl...@major-k.de _______________________________________________ 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