I have 2 tables registration , student
registration table includes regid, mobno, status
student table includes - studid, name, address, emailid, father , mother , fathermobno, mothermobno, smsno, other details....
In the registartion form , they have to give any of their mobile nos ( fathermobno, mothermobno, smsno)
and submit the form.
then i have to check whether the mobile number they entered at the time registration is matching with any of the mobile nos in the student table.
How i can check so? could any one help me the sql query for that?