Reply To: percentage in sql

• greatblakes

• June 12, 2018 at 6:43 am

I luckily found a cached version of that support thread. Looks like the support forum’s syntax highlighter library is broken or not loading. Anyway here is the snippet that @kokers provided there:

function my_posts_where( $where ) {
    global $wpdb;
    $where = str_replace(
              "meta_key = 'locations_%", 
              "meta_key LIKE 'locations_%",
              $wpdb->remove_placeholder_escape($where)
    );
    return $where;
}
 
add_filter('posts_where', 'my_posts_where');