Quick SQL question

[Peter Haworth]

I'm thinking this may not give you the same results as checking each column
individually.  Is the need to check for the same value in each column or
for a different value in each column?

Pete
lcSQL Software <http://www.lcsql.com>


On Mon, Jul 15, 2013 at 6:39 AM, Klaus major-k <klaus at major-k.de> wrote:

>
> Am 15.07.2013 um 15:59 schrieb john at splash21.com:
>
> > Googling it suggests that '||' is concatenate in SQLite, so try;
> >
> > WHERE (name || tags || comment) LIKE '%.....
>
> Wonderful, will try this!
> Thanks a bunch!
>
>
> Best
>
> Klaus
>
> --
> Klaus Major
> http://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
>