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