in reply to Re^2: Looking for neater solution with dynamic query
in thread Looking for neater solution with dynamic query

A lot will depend on the way DBD for this type of database is implemented. Last time I looked at it, DBD:mysql did all the binding internally and presented a literal query string to the database-engine (the prepare-method wasn't even send to the database!), so there was no speed benefit in binding. It may have changed in more recent versions. You still had the security benefit and the cleaner code of course.

CountZero

"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law