query to bring columns in single row

1
votes

I have a table like below


    CREATE TABLE `fruits` (
      `fruit_id` int(11) default NULL,
      `fruit_name` varchar(255) collate latin1_general_ci default NULL
    );

The table contains fields as below

    INSERT INTO fruits(fruit_id, fruit_name) 
               VALUES (101, 'Mango'),
                      (102, 'Apple'),
                      (103, 'Orange'),
                      (104, 'Pineapple'),
                      (105, 'Lemon'),
                      (106, 'Custard');

I want a select query which brings the column in to single row as below for particular id like 

    SELECT fruit_id, fruit_name
       FROM fruits
      WHERE fruit_id = 101

The above query bring output in two columns 

    101    Mango

I want the columns in single row as below


    101
    Mango
1
mysqlsql

1 Answers

1
votes
SELECT row
FROM
(
  SELECT fruit_id, fruit_id row FROM fruits
  UNION
  SELECT fruit_id, fruit_name row FROM fruits
) s
WHERE fruit_id = 101;