compare two coloums select only selected text ""
i have table like this
sno name father_name
1 raju reddy srinivas reddy
2 praveen reddy raju vardhan
3 praveen goud raju
4 srinu shashireddy
5 narsimha goud veeresh
i want compare name & father_name select only "reddy " row only
i want output like this......
sno name fathername
1 raju reddy srinivas reddy
2 praveen reddy raju vardhan
4 srinu shashianireddy
plz write quarie ...............