WordPress: SQL to migrate posts from a single category to its own custom post type

category-to-cpt.sql

UPDATE wp_posts
  inner join wp_term_relationships    rel   on  wp_posts.id=rel.object_id
  inner join wp_term_taxonomy         tax   on  rel.term_taxonomy_id=tax.term_taxonomy_id
  inner join wp_terms                 term  on  tax.term_id=term.term_id
  set wp_posts.post_type='your_post_type'
WHERE
term.slug="category_name"

This gist was justly gisted.