SQL PHP search LIKE two columns?

Question

I have the below query;

SELECT * FROM `` WHERE `fname` LIKE 'argument' OR `lname` LIKE 'argument'

What do I need to change in order to 'concatenate' the columns so that I can search for rows LIKE fname.lname ?

Gordon Linoff · Accepted Answer · 2015-04-13 12:40:44Z

5

Perhaps you want to concatenate the fields together for the like:

SELECT *
FROM staff 
WHERE concat_ws(' ', fname, lname) LIKE '%".$searchq."%';

If the comparison could go either way, then you might want two comparisons:

SELECT *
FROM staff 
WHERE concat_ws(' ', fname, lname) LIKE '%".$searchq."%' or
      concat_ws(' ', lname, fname) LIKE '%".$searchq."%'

answered Apr 13, 2015 at 12:40

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1