in reply to DBI, quoting, and LIKE searches
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.
|
|---|