CREATE TABLE `fruits` ( `fruit_id` int(11) default NULL, `fruit_name` varchar(255) collate latin1_general_ci default NULL ); INSERT INTO fruits(fruit_id, fruit_name) VALUES (101, 'Mango'), (102, 'Apple'), (103, 'Orange'), (104, 'Pineapple'), (105, 'Lemon'), (106, 'Custard');
SELECT row FROM (SELECT fruit_id, CAST(fruit_id AS CHAR(255)) row FROM fruits UNION SELECT fruit_id, CAST(fruit_name AS CHAR(255)) row FROM fruits) s WHERE fruit_id = 101;
Output
101 Mango