parameterized query with wildcard
Mike Kerner
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
mailing list