SQL(ite) question

[Pi Digital]

Even easier:

SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE ‘%mysearchtermhere%’)

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
> 
> 
>> On Jan 13, 2020, at 11:03 , Klaus major-k via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> Hi all,
>> 
>> I searched the docs of SQLite but could not find a hint.
>> 
>> Is it possible to create a "full text search" in SQL(ite)
>> with ONE SQL command? Something like this (pseudocode):
>> ...
>> SELECT * from MyTable where ANY_COLUMN like "%mysearchtermhere%"
>> ...
>> If not, how can this be done?
>> 
>> You get the picture, any hints appreciated, thank you.
>> 
>> 
>> Best
>> 
>> Klaus
>> --
>> Klaus Major
>> https://www.major-k.de
>> klaus at major-k.de
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode