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@lists.runrev.com> wrote: > > Hi Sean, > >> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode >> <use-livecode@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@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 >>> > _______________________________________________ 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
