Concat fields in mysql

By using CONCAT function in mysql, we can concat fields or string.

SELECT CONCAT('field1', '-', 'field2', '-', 'field3');
// Output:
// 'field1-field2-field3'

Post Views: 34