in reply to DBI, quoting, and LIKE searches

What is the best way to construct a LIKE search with DBI?

There's a discussion of binding and LIKE clauses in A DBI Query Binding Pitfall. The upshot is that RDBMS query optimizers will assume the worst if they see a LIKE clause but don't have a string to examine to see if index use is possible. There are workarounds.