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