SELECT *, concat(substr(acctCode, 1, 4), "-", substr(acctCode, 5, 3), "-", substr(acctCode, 8, 2), " [", acctName, "]") as fad
FROM (`comp_chart_of_acct`)
WHERE `companyID` =  '3'
ORDER BY `acctCode`