Answers for "mysql concat two columns in where clause"

mysql concatenate two columns into one

SELECT concat(first_column, ' ', second_column) from table_name

Posted by: Guest on February-22-2021

mysql concat and use as where column

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

Posted by: Guest on November-04-2020

Code answers related to "mysql concat two columns in where clause"