select 1 from dotlrn_community_types
where community_type = :community_type
select
pretty_name,
description
from
dotlrn_community_types
where
community_type = :community_type
update
dotlrn_community_types
set
pretty_name = :pretty_name,
description = :description
where
community_type = :community_type