parameterized query with wildcard
bobsneidar at iotecdigital.com
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’
> 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:
More information about the use-livecode