On Wed, May 28, 2003 at 12:31:33PM -0400, Thomas Good wrote: > Hi, how does one use LIKE and a wildcard with variable binding?? > > $q = qq |select * from x where y like ?|; > ... > $sth->execute($some_variable) > > where does the % go??
my $some_variable = '%here%'; The placeholder variables generally get passed in as-is, and % is just a part of a placeholder string, so far as the database is concerned. -johnnnnnnnnnnn
