Which column matches?

Question

How do I know which column matches if I have two sentences LIKEfor two different columns, and in the end one of the two columns contains a needle.

Answer 1

you can do something like:

SELECT 1 AS `match`, * FROM `table` WHERE col1 LIKE 'needle%'
UNION 
SELECT 2 AS `match`, * FROM `table` WHERE col2 LIKE 'needle%'

and use matchto know

Note: this can probably be written using IF()

Answer 2

SELECT
  IF(col1 LIKE 'needle%' AND col2 LIKE 'needle%', 0, IF(col1 LIKE 'needle%', 1, 2)
    AS match, 
  *
FROM
  table
WHERE
  col1 LIKE 'needle%'
OR
  col2 LIKE 'needle%'

match teklls that the columns fall into:

• 0 = both
• 1 = match on col1
• 2 = match on col2

Answer 3

You can use your PHP section to check which one matches.

if (stristr($result['col1'], $queryvar) === true) // col1 matched