select count(*)
from recruiting_assignment_emails
where package_id = :package_id
select email_body
from recruiting_assignment_emails
where package_id = :package_id
select email_body
from recruiting_assignment_emails
where package_id is null
select count(*)
from recruiting_assignment_emails
where package_id = :package_id
update recruiting_assignment_emails
set email_body = :email_body
where package_id = :package_id
insert into recruiting_assignment_emails
(package_id,
email_body)
values (:package_id,
:email_body);