Searching full name or first or last name in MySQL database with first and last name in separate columns

mysql, php

Solution

SELECT * 
FROM table
WHERE CONCAT( nameFirst,  ' ', nameLast ) LIKE  '%Joe%'

Be sure to sanitize any user submitted parameters such as "Joe"

Problem

I'm working with an existing database that has first name and last name seperated in the database. I need to create a function that will take one search input and return results. say my database has a structure like.... ``` nameFirst nameLast Joe Smith Joe Jones Joe Brown ``` How could I, using MySql, take a search input that is say 'Joe Smith' and just get his row? But if I put just 'Joe' in the search field, return them all? Will I need to explode the string with a space? thanks!

Original source