Code: Select all
$toSearch = 'Harrison Dano';
$conditions = array();
$aray = explode(' ',$toSearch);
foreach($aray as $keyword){
$conditions[] = "lname like '$keyword%' OR fname LIKE '$keyword%'";
}
$query = "SELECT lname,fname FROM directory WHERE ".implode(' OR ',$conditions);
/* the query must be ...
SELECT lname,fname FROM directory
WHERE lname LIKE 'Harrison%' OR fname LIKE 'Harrison%' OR
lname LIKE 'Dano%' OR fname LIKE 'Dano%'
*/Code: Select all
George Harrison
Harrison Ford
Emanuel Danobelle
Harrison Dano <-- The exact match is sadly not the first itemThank you in advance.