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

Vulpes · Answer

Try: select * from tablename where name like '%reddy' and location='hyd' and gender='male';