Check out example codes for "mysql concat and use as where column". It will help you in understanding the concepts better.

Code Example 1

CONCAT (string1, string2,…) AS column_name

Code Example 2

select * from table where concat_ws(' ',first_name,last_name) 
like '%$search_term%';

Learn ReactJs, React Native from akashmittal.com