compare three fields ....................

Question

I HAVE TABLE LIKE THIS...

sno          name      l      ocation    gender    

1        raju reddy       hyd      male
2        praveen         vizg      female
3        srinu              sdf       male

compare thee coloums
select name like reddy     and    location  hyd   and gender male 
i want output like this below

sno     name          location      gender
1      raju reddy      hyd            male