how to select subscribers.

Hello everyone,

I’m searching for wordpress query to select all subscribers for sorting by first name and last name, City, Specialization i’v already tried below query

SELECT * FROM wp_usermeta WHERE ((meta_key like ‘%first_name%’ || meta_key like ‘%last_name%’) AND meta_valuelike’%Chandrakant%’) || (meta_key=’City’ AND meta_value=”) || (meta_key=’Specialization’ AND meta_value=’%%’) AND user_id IN (SELECT user_id FROM wp_usermeta WHERE meta_key = ‘wp_capabilities’ AND meta_value = ‘a:1:{s:10:”subscriber”;b:1;}’)

it’s working but problem is

when i search by individual first name or last name then I’ll working properly but when i tried to both my fist name and last name then query will be fine but result not dispayed.

Please help me.

Thanks in advanced.