Is your WordPress between query not displaying the correct results for a numerical numbered integer value at three numbers? All you may need is to set a type.
1 answers
1
Get results between two numbers
If you’re having trouble looping through posts that sometimes show results and sometimes don’t with a between meta_compare set, you may be telling the loop to loop between two dates and not numbers.
In order to solve this, you should add a type as per the below example.
$min_value = 150; $max_value = 300; $args = array( 'post_type' => 'example_post_type', 'posts_per_page' => -1, 'meta_key' => 'your_meta_key', 'meta_value' => array( $min_value, $max_value ), 'meta_compare' => 'BETWEEN', 'meta_type' => 'NUMERIC' );
Note, using type instead of meta_type will work in a meta_query array.
— Support WizardAnswer 1