Context. I have a live search script where you can write for example name or part of it and it gives you the result using the following query:
$sql = "SELECT * FROM ext_extensions WHERE ext LIKE '%$param%' OR firstname LIKE '%$param%' OR lastname LIKE '%$param%' OR department LIKE '%$param%' OR location LIKE '%$ param%'";
The thing is, I can't go by firstname + lastname at the same time, so I have to go as firstname OR lastname. Is there anything I can do to be able to search by {First Name}' '{Last Name}?
I've tried to concat firstname' 'lastname but I'm not able to use this concatenation on where clausule.