CodeIgniter Ignited Datatables将2个查询字段组合为1列

Question

I have a table Person with fields LastName, FirstName and MiddleName.

I would wanted to display in datatable as one column the LastName, FirstName MiddleName

Is it possible? How?

Answer 1

I believe you can do SELECT CONCAT(LastName, ", ", FirstName, " " , MiddleName ) as Name FROM Person. This will concat all names in one column named Name. Second blank " " is to set a gap between First and Middle Name.