How to Concatenate two fields in MySql?

Answer 1

Try this
SELECT CONCAT (first field, 'connector for example -', second field) from table

Answer 2

In MySQL CONCAT function is used to concatenate two strings to form a single string

Synatx : SELECT CONCAT(column1,column2) FROM tblname.
Ex : SELECT CONCAT(first_name,last_name) FROM employee