Concatenation of data in a select field

Hi all,

I try to display 2 or 3 values ​​from a table in a select field.
I have a table with an Author Id, name, surname, birth, death.

I created a select field FLEXIcontent where I put this query: SELECT `id` AS value, `name` AS text FROM AS fi author order by author.
It returns me the correct name but I can not find how to display the name and first name the rest.
Thank you for your help.

Hi,

May be you can use the CONCAT_WS Mysql function.
Eg :
dev.mysql.com/doc/refman/5.0/fr/ ... tions.html

Regards

Thank you very much, it works !