Special Content

Get rid of this Strict Standards warning WooCommerce: get_current_screen not working with multi language Can’t login on WordPress Force HTTPS using .htaccess – stuck in redirect loop WordPress: Ajax not working to insert, query and result data

Home Science, Programming and Technology WordPress Custom query with DECIMAL(5,2)

Custom query with DECIMAL(5,2)

February 24, 20232 Views

placeholder

I want to know if there is a way to DECIMAL (5,2) instead of DECIMAL in meta_query

Post Views: 2

Leave a Reply Cancel reply

You must be logged in to post a comment.

1 comment

Answer taken from here: meta_query: using BETWEEN with floats and/or casting to DECIMAL

add_filter('get_meta_sql','cast_decimal_precision');

function cast_decimal_precision( $array ) {

    $array['where'] = str_replace('DECIMAL','DECIMAL(5,2)',$array['where']);

    return $array;
}