How to make such a request?

Question

MySQL

Contained in the table:

profile_id          car_id
1                      4
1                     14
1                     21

The query result should be:

profile_id      car_one       car_two      car_three
1                    4           14           21

Answer 1

Even if you write such a request, I'm sure the people who will maintain your code will hate you, your relatives, and so on.
DB for storing data, and for optimal, fast selections.
And already, please, wrap the display logic in the Server Programming Language. This will take 3 lines of code.
PS Of course, I'm talking about code that should reach production someday. If this task is for educational purposes, then good luck)

Answer 2

IMHO You will need a separate table for this with
car_name car_id
car_one 4
car_two 14 then
join and pivot

Answer 3

I advise you to take a closer look at this link - forums.mysql.com/read.php?20,75357,75357#msg-75357

Answer 4

SELECT profile_id, GROUP_CONCAT(car_id separator ';') as cars FROM `table` GROUP BY profile_id

Then explode and that's it