How to return multiple fields as a single array or string?

Question

I have a table in the database with several phones, the name of the fields is numbered as follows: telefone1, telefone2, telefone3 your return is like this:

Array
(
    [telefone1] => 190
    [telefone2] => 197
    [telefone3] => 140
)

What I’d like to do is in select, instead of returning multiple phones, return an array with all, something like that:

Array
(
    [telefone] => Array
        (
            [0] => 190
            [1] => 197
            [2] => 140
        )

)

Or even join the fields with some character, for example, comma:

190,197,140

Answer 1

You can use the command concat_ws, in the specification, says that uni string according to a separator, better explanation in https://www.w3resource.com/mysql/string-functions/mysql-concat_ws-function.php Your select would look like this SELECT CONCAT_WS(" , ", telefone1, telefone2, telefone3) AS telefones , remembering that this works if phones are strings.