SQL(ite) question
Pi Digital
sean at pidigital.co.uk
Mon Jan 13 20:04:35 EST 2020
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
More information about the use-livecode
mailing list