Loading

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

JAYRAM

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Try:

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