Quick SQL question

Peter Haworth pete at lcsql.com
Mon Jul 15 11:39:08 EDT 2013


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
>



More information about the use-livecode mailing list