parameterized query with wildcard
MikeKerner at roadrunner.com
Tue Jul 28 11:16:57 EDT 2015
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."
More information about the Use-livecode