I want to get meta data by custom post type category name.
Right now i am getting all meta data but i want specific for each category
$partSql = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."postmeta WHERE meta_key = 'prd_part_no'", ARRAY_A);
You can use the get_post_meta function in wordpress to achieve this, that's a link get_post_meta to it in the wordpress codex.