SQL(ite) question

[Klaus major-k]

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
>> 
>>> 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%"
>>> ...
>>> ...

Best

Klaus

--
Klaus Major
https://www.major-k.de
klaus at major-k.de