Re: DBI Question

[jreades]

You can do this:

$sth = $dbh->prepare("SELECT name FROM people WHERE name LIKE ?");
$sth->execute('%foo%');

Just, remember, as I said in chatterbox, to escape the wildcard character '%'.

[dsb]

The value I will bind to the placeholder is SCALAR variable. Can this still be done like:

$sth = $dbh->prepare("SELECT name FROM people WHERE name LIKE ?");
$sth->execute( "$foo\%" );

[jreades]

You'll have to test it for yourself, but I don't see why not...

An easier way, if you know that you're always doing wildcard searches, might be:

$sth->execute('%' . $foo . '%');

[dsb]

That helps alot...Thanks!!!