MySQL 5.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


5.5.62


CREATE TABLE `room_map` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `room_num` int(10) unsigned NOT NULL,
  `connected_rooms` text NOT NULL,
  PRIMARY KEY (`id`,`room_num`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `idx_room_map_room_num` (`room_num`)
) ENGINE=MyISAM AUTO_INCREMENT=124788 DEFAULT CHARSET=latin1;
INSERT INTO room_map (room_num, connected_rooms) VALUES (25690, '15002/25682/'), 
(25682,'25669/25690/'),(25669,'25667/25682/24324/'), (25667,'25669/24324/'), 
(24324,'25667/25669/24323/'), (24323,'24324/2743/'), (24322,'2738/23957/19637/');
select * from room_map;


id
room_num
connected_rooms


124788
25690
15002/25682/

124789
25682
25669/25690/

124790
25669
25667/25682/24324/

124791
25667
25669/24324/

124792
24324
25667/25669/24323/

124793
24323
24324/2743/

124794
24322
2738/23957/19637/

id	room_num	connected_rooms
124788	25690	15002/25682/
124789	25682	25669/25690/
124790	25669	25667/25682/24324/
124791	25667	25669/24324/
124792	24324	25667/25669/24323/
124793	24323	24324/2743/
124794	24322	2738/23957/19637/