How to display datas using query data from multiple specific rows in one table sql into multiple columns? For example, insert red data into column1, insert blue data into column2, insert green data into column3, etc.
I've used these code : SELECT um_value FROM _wp_um_metadata_
WHERE um_key='first_name'
But the result I only got one column.
Please help if someone has expert knowledge about MySQL here. Thanks for sharing it.
Here the screenshot of example sql database :
