wp_query_with_decimals_in_meta_query.php

<?php
$args = array(
	'post_type'     => 'post',
	//'category_name' => 'markup',
	'meta_query'    => array(
		array(
			'key'     => 'rating',
			'value'   => array( 2.42, 2.47 ),
			'compare' => 'BETWEEN',
			//'type'    => 'NUMERIC',
			//'type'    => 'DECIMAL',
		),
	),
	'posts_per_page'      => -1,
	'orderby'             => 'meta_value_num',
	'order'               => 'DESC',
	'post_status'         => 'publish',
	'ignore_sticky_posts' => true,
);
$query = new WP_Query( $args );
if ( $query->have_posts() ) {
	echo '<ul>';
	while ( $query->have_posts() ) {
		$query->the_post();
		$the_custom_field = get_post_meta( $query->post->ID, 'rating', false );
		?>
		<li style="margin-bottom: 1em;">
			Post title: <a href="<?php echo esc_html( get_permalink( $query->post->ID ) ); ?>"><?php echo esc_html( get_the_title( $query->post->ID ) ); ?></a><br />
			Category: <?php echo get_the_term_list( $query->post->ID, 'category', '', ', ', '' ); ?><br />
			Rating: <?php echo esc_html( $the_custom_field[0] ); ?>
		</li>
		<?php
	}
	echo '</ul>';
} else {
	echo '<p>No posts yet.</p>';
}
wp_reset_postdata();
?>