movies_appeared_in

// WP_Query arguments
$args = array(
	'post_type'              => array( 'movies' ),
	'post_status'            => array( 'publish' ),
	'meta_query'             => array(
		array(
			'key'     => 'cast_per_role_%_actor',
			'value'   => 'meta_value',
			'compare' => 'LIKE',
		),
	),
);

// The Query
$query = new WP_Query( $args );

// The Loop
if ( $query->have_posts() ) {
	while ( $query->have_posts() ) {
		$query->the_post();
		// do something
	}
} else {
	// no posts found
}

// Restore original Post Data
wp_reset_postdata();