How MYSQL query, A field=A field, A newline + B field

For example, A field=name
Field=B on January 1, 2013
If check out results in the article page is shown as

B field results for name
On January 1, 2013


Is B field is equal to A + B, they are not together at the same time with line breaks

CodePudding user response:

SELECT A, CONCAT (A, '\ r \ n, B) as B FROM the name of the table

CodePudding user response:

SELECT A field, B fields, CONCAT (A field, UNHEX (' 0 d0a), field B) FROM the name of the table;