parameterized query with wildcard

[Bob Sneidar]

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’

HTH

Bob S


> On Jul 28, 2015, at 08:16 , Mike Kerner <MikeKerner at roadrunner.com> 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 lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode