Check out example codes for "sql recherche nom prenom". It will help you in understanding the concepts better.

Code Example 1

SELECT * 
FROM personne 
WHERE nom LIKE '".$debut."%'
OR prenom LIKE '".$debut."%'
OR CONCAT(prenom, ' ', nom) LIKE '".$debut."%'

Learn ReactJs, React Native from akashmittal.com