select short_name from pinds_blog_categories where package_id = :package_id update pinds_blog_categories set name = :name, short_name = :short_name where category_id = :category_id select category_id from pinds_blog_categories where package_id = :package_id and name = :category_name