prepare("select concat(firstName,' ',lastName) as name, match(details) against('$query') as relevance from testTable where match(details) against ('$query')");*/ $result = $dbh->prepare("select firstName, lastName from testTable where details like '%$query%'"); $result->execute(); } ?> fetch()){ echo ''; } } ?>

Student Practice Queries

Name Relevance
'.$row[0].' '.$row[1].''. $row['relevance'].'
Search me