Mysql字符串连接

select CONCAT(field1, '@', field2) as aa
from table_name