Search Custom Fields by Wildcard

• thepaperplant

• April 18, 2019 at 7:12 am

I am trying to query posts by a custom field (not a subfield) using a wildcard. What I am trying to do is get all posts where the last name starts with the letter “A%” or “B%” etc etc. Cannot find any documentation on this, but surely it must be possible? MY WP Query code is below (but brings back 0 results).

$group1 = new WP_Query(array(
'post_type' => 'oral_histories',
'posts_per_page' => -1,
'meta_key'	=> 'last-name',
'orderby'	=> 'meta_value',
'order'		=> 'ASC',
'meta_query'	=> array(
 'relation'		=> 'OR',
 array(
'key'		=> 'last-name',
 'value'		=> 'A%',
'compare'	=> 'LIKE'
),
 array(
'key'		=> 'last-name',
'value'		=> 'B%',
'compare'	=> 'LIKE'
)
)
));

• John Huebner

• April 20, 2019 at 12:52 am

$group1 = new WP_Query(array(
'post_type' => 'oral_histories',
'posts_per_page' => -1,
'meta_key'	=> 'last-name',
'orderby'	=> 'meta_value',
'order'		=> 'ASC',
'meta_query'	=> array(
 'relation'		=> 'OR',
 array(
'key'		=> 'last-name',
 'value'		=> '^A',
'compare'	=> 'REGEXP'
),
 array(
'key'		=> 'last-name',
'value'		=> '^B',
'compare'	=> 'REGEXP'
)
)
));