select id,full_name,email_id,phone,address,blood_group,created_on,sex from user_master where inactive=0 and (full_name like '%%' or phone like '%%' or email_id like '%%') and sex in(0,1) order by photo desc limit 0,100