I have a custom post type MEMBER and there is a meta field member_name now I want search all member whose name start with 'S' .
normal SQL : WHERE member_name like 'S%';
How can it be done in wordpress ?
What I did as bellow:
$arg = array(
'post_type' => 'member',
'post_status' => 'publish',
'order' => 'ASC',
'meta_key' => 'member_name',
'orderby' => 'meta_value',
'meta_query' => array(
array(
'key' => 'member_name',
'value' => $sort_by,
'compare' => 'LIKE'
)
)
);
$wp_query = new WP_Query($arg);