in reply to Best way to deal with quotes in string with DBI
Using placeholders. See this tutorial
Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."