CODE EXAMPLE FOR SQL

Combine two columns in SQL for WHERE clause

WHERE CONCAT(customers.first_name, ' ', customers.last_name) LIKE '%John Smith%'