This is PerlMonks "Mobile"
in reply to SQL Placeholders - clarification
Another benefit, especially useful for bulk operations, is that you can "prepare" the SQL query once, with its placeholders, and then re-execute that prepared query-handle as many times as you wish, substituting different placeholder values each time.