id, ch1, ch2, ch3, ch4

select.sql

CREATE TABLE IF NOT EXISTS `concat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ch1` varchar(41) NOT NULL,
  `ch2` varchar(41) NOT NULL,
  `ch3` varchar(41) NOT NULL,
  `ch4` varchar(41) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `concat`
--

INSERT INTO `concat` (`id`, `ch1`, `ch2`, `ch3`, `ch4`) VALUES
(1, 'a', 'b', 'c', 'd'),
(2, 'g', 'i', 'q', 'm'),
(3, 'g', 'r', 'a', 'm');


SELECT * FROM `concat` WHERE `ch1` LIKE 'g' AND `ch2` LIKE 'r' AND `ch3` LIKE 'a' AND `ch4` LIKE 'm';