insert into bt_components (component_id, project_id, component_name, description, url_name, maintainer) values (:component_id, :package_id, :name, :description, :url_name, :maintainer) update bt_components set component_name = :name, description = :description, maintainer = :maintainer, url_name = :url_name where component_id = :component_id select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from cc_users u where upper(coalesce(u.first_names || ' ', '') || coalesce(u.last_name || ' ', '') || u.email || ' ' || coalesce(u.screen_name, '')) like upper('%'||:value||'%') order by name