parameterized query with wildcard

Bob Sneidar bobsneidar at
Wed Jul 29 01:23:58 CEST 2015

Should be LIKE ‘:1’ or for wild cards LIKE ‘%:1%’. 

If you are searching for a value at the beginning, LIKE ‘:1%’ or at the end, LIKE ‘%:1’

If searching for all, column LIKE ‘%:1%’ OR column LIKE ‘:1%’ OR column LIKE ‘%:1’


Bob S

> On Jul 28, 2015, at 08:16 , Mike Kerner <MikeKerner at> wrote:
> Has anybody built any queries that use both parameters and wildcards, e.g.
> in a LIKE statement?
> SELECT * FROM foo WHERE bar LIKE %:1%
> I've tried the above (error), I've tried '%':1'%' (error), and I've tried
> appending the % to the container I'm passing as my :1 (doesn't work).
> I really don't want to do this the unsafe way.
> -- 
> On the first day, God created the heavens and the Earth
> On the second day, God created the oceans.
> On the third day, God put the animals on hold for a few hours,
>   and did a little diving.
> And God said, "This is good."
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the use-livecode mailing list