To concat in MySQL you can use the concat or concat_ws function.
Sample CONCAT
SELECT concat('HELLO','|','WORLD','|','TEST');
output
HELLO|WORLD|TEST
Sample CONCAT_WS
SELECT concat_ws('|','HELLO','WORLD');
output
HELLO|WORLD|TEST
for more informations see DEV.MYSQL: Concat, CONCAT_WS
RT @CodeSnippetsNET: How to concat in #MySQL http://t.co/GISKs5h59K #sql #php #html #css #php #programming #code #coding