"searching full name or first or last name in mysql database with first and last name in separate columns" Code Answer

1
select * 
from table
where concat( namefirst,  ' ', namelast ) like  '%joe%'  

be sure to sanitize any user submitted parameters such as "joe"

By Slaawwa on July 28 2022

Answers related to “searching full name or first or last name in mysql database with first and last name in separate columns”

Only authorized users can answer the Search term. Please sign in first, or register a free account.