my %search_library = (
  email => $dbh->prepare(q{
    SELECT filename, type
    FROM library
    WHERE
      filename = ?
      AND filetype = 'email'
  }),
  article => $dbh->prepare(q{
    SELECT filename, type
    FROM library
    WHERE
      filename = ?
      AND filetype = 'article'
  }),
  both => $dbh->prepare(q{
    SELECT filename, type
    FROM library
    WHERE
      filename = ?
      AND (filetype = 'email' OR filetype = 'article')
  }),
);