Skip to Main Content

Show and Tell

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

How to query selected multiple rows into multiple colums

Harry TiadiJan 8 2024

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 :

Comments
Post Details
Added on Jan 8 2024
0 comments
39 views