SELECT id, lastname, concat_ws(firstname, '', lastname) as name FROM student