mysql table having a->b and b->a values, select only a->b set of values -

i have 1 table having 5 columns

linkid, orinodeno, orinodeno, ternodeno, terifindex

linkid autoincremented. orinodeno, oriifindex 1 combination value , ternodeno, terifindex other combination (orinodeno,oriifindex originating value , ternodeno,terifindex terminating value i.e, in between there link eg map 2 pts n in between connecting link) table contains a->b values (i.e combination of orinodeno, oriifindex , b combination of ternodeno,terifindex) , b->a values. have select a->b set of values not b->a. sending table image. my table

there no map definition in sql databases, forget it. check database normalization tutorial. shouldn't have problems select statements.