Compare two meta key values with between value

Records in CPT are as follow

$meta_query = array(
    'relation' => 'OR',
    array(
        array(
            'key' => '_size',
            'value'    =>  array(1000, 5000),
            'type'     => 'decimal(10, 2)',
            'compare'  => 'between'
        ),
        array(
            'key' => '_size_to',
            'value'    =>  array(1000, 5000),
            'type'     => 'decimal(10, 2)',
            'compare'  => 'between'
        ),
    ),
);

After applying above meta_query not able to get actual output

Expected Output

Actually it’s working like below SQL’s. Please review once and let me know best fit for this situation.

Right Now

SELECT * FROM test WHERE _size BETWEEN (1000 AND 5000) OR _size_to BETWEEN (1000 AND 5000)

Trying to do like below

SELECT * FROM test WHERE 1000 BETWEEN (_size AND _size_to) OR 5000 BETWEEN (_size AND _size_to)

You need to sign in to view this answers