SQL find which OR was mapped

Question

In a statement like:, SELECT * FROM tbl1 WHERE row1=val1 OR row2=val2is it possible to find out which string was matched? If so, how can this be done? And how would you capture this in PHP?

Answer 1

Use operator Case/IF

SELECT *,
       case when row1='val1' then 'row1' else 'row2' end as matched col
FROM tbl1
WHERE row1='val1' OR row2='val2'

Operator

Casecan be replaced by the operator IFas follows

IF(row1='val1','row1','row2')