Bob Sneidar wrote:
> Yes, but the original question was about whether or not it could be
> done with a single statement. Also I am not a big fan of full text
> searches the way they are implemented typically. For instance, on our
> copier vendor's websites they of course have searches, but what I
Yes, but the original question was about whether or not it could be done with a
single statement. Also I am not a big fan of full text searches the way they
are implemented typically. For instance, on our copier vendor's websites they
of course have searches, but what I end up with are 10,000
Bob Sneidar 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.
Wouldn't that be a
Pretty sure + means concatenate, otherwise that SQL statement would not work in
any I can imagine.
Bob S
> On Jan 14, 2020, at 10:05 , Klaus major-k via use-livecode
> wrote:
>
> Hi Bob,
>
>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode
>> :
>>
>> The only problem I see
Hi Bob,
> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode
> :
>
> 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
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
> wrote:
>
> Hi Sean,
>
Hi Sean,
> Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode
> :
>
> 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
On 1/13/20 3:03 PM, doc hawk via use-livecode wrote:
On Jan 13, 2020, at 11:39 AM, Mark Wieder via use-livecode
wrote:
Single command? No.
Also, note that you *can* submit compound commands from LiveCode to SQLite and
PostgreSQL, unlike with mySQL. (Or, maybe the interface to mySQL has
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
>> wrote:
> Actually I do this all the time.
>
> SELECT * from MyTable where
> COLUMN1 like
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 ,
On Jan 13, 2020, at 11:39 AM, Mark Wieder via use-livecode
wrote:
>
> Single command? No.
Also, note that you *can* submit compound commands from LiveCode to SQLite and
PostgreSQL, unlike with mySQL. (Or, maybe the interface to mySQL has changed
in the years since I learned this the hard
Hi Mark,
> Am 13.01.2020 um 20:39 schrieb Mark Wieder via use-livecode
> :
>
> On 1/13/20 11:03 AM, Klaus major-k via use-livecode 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?
On 1/13/20 11:03 AM, Klaus major-k via use-livecode 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
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
14 matches
Mail list logo
