Mysql concat usage
Multiple fields are spliced into a single field for query
SELECT
CONCAT (area.name
House.block
'Dong'
House.unit
'unit'
House.room_number
'Room'
Room.apart_name) AS name
FROM
House_apart AS room
Query result
Name
Aaa', Room 1, Unit 1, Building 2, Shanghai
'Unit 1, Unit 1, Room A1, Building 2, Shanghai'
